This video saved my task. Thank you so much! I actually saw some other video and got confused but after watching this I could create my task in 10 min.
Great video. I had one issue - this only works well if the data is of the same type. How do you do this is the data you want is of different types (percentage vs. number over time) The horizontal axis at the bottom is date, I need to see at what point a specific date a count (number) crosses efficiency (percent - %). The data given to me in one chart with multiple columns labeled "count and efficiency. The data running vertically on the left are the dates.
Is there a way to add many series quickly to the one chart withough manually reading-in the cell ranges? Say if there are only 3 columns in the worksheet, 2 being the X & Y numerical variables, & the other being a categorical variable for which we want a separate series?
Great video, thanks for the help. I still had a tough time plotting two sets of water elevation over time. One set of data from the US Geographical Survey (data taken every 3 minutes), and one set of monthly data that was hand written (data taken at random times maybe once a day over the course of a month). The thing is, I discovered that you must have the same time and equal number of time stamps in each data set. So you must copy the handwritten times to the USGS data to the closest time which is what I did. Or I could write a script to extrapolate the USGS elevation, and add a record that matches the time of the handwritten time. And MS Access? I couldn't find a way to graph two record sources.
how come whenever I try to do the same thing except when I dont do CTRL+shift+down and i just click and drag down I can then no longer select y-values?
Here is my problem: I have two sets of data (one sorted ascending, the other descending). When I select the 1st series, it added to the Graph as usual. When I select the 2nd series (descending data), it only added the 1st data point...