Quote:
Originally Posted by skeezix
The attached Excel file demonstrates the problem.
|
Hi, Skeezix,
Two things: First, I suggest you make your data a proper table, so that you'll be sure that it picks up subsequent rows as you add them at the bottom.
Second, the reason you might not see individual dates on your chart is because the X Axis is set as a "Date Axis." When I opened it it shows the units both major and minor are 15 days.
I noticed you're working with Excel 97-2003 (.xls) files, so maybe you have an older version and controls might not look exactly the same. But, when you work with a date axis, generally it's designed to plot data along an incremental time line (in your case, 15 days). By changing it to a text axis and changing the controls, I was able to see a plot of every single entry you made, plus I made a few more by copying previous lines to a new date at the bottom.
Incidentally, you'll see the line for Pulse didn't extend - because the way you'd selected your data for Pulse, it didn't expand to accommodate new rows. That's why starting with your data as a table can be beneficial.