E
Eli
This must be incredibly easy, but I've poked around in most of the
chart options I can find and haven't been able to see it. I have a
sheet that looks something like:
6/11/05 6/12/05 6/13/05 ...
Inventory Totals
A 419 431 432 ...
B 145 145 144 ...
I'm charting only the values in the A row, 419, 434, etc. An
appropriate range is shown on the Y axis. I have the X axis formatted
as dates, but I get the dates 1/1, 1/2, etc. How do I tie the X axis
labels to the dates in my data?
Another question: This data will grow indefinitely. How can I specify
a cell range for the chart so that I don't have to respecify it every
day? That is, when I add columns P and Q and R to my spreadsheet, the
chart would pick them up automatically, but also not display any blank
dates at the righ-hand end of the chart.
chart options I can find and haven't been able to see it. I have a
sheet that looks something like:
6/11/05 6/12/05 6/13/05 ...
Inventory Totals
A 419 431 432 ...
B 145 145 144 ...
I'm charting only the values in the A row, 419, 434, etc. An
appropriate range is shown on the Y axis. I have the X axis formatted
as dates, but I get the dates 1/1, 1/2, etc. How do I tie the X axis
labels to the dates in my data?
Another question: This data will grow indefinitely. How can I specify
a cell range for the chart so that I don't have to respecify it every
day? That is, when I add columns P and Q and R to my spreadsheet, the
chart would pick them up automatically, but also not display any blank
dates at the righ-hand end of the chart.