Data Ranges for Charts
Posted by Scott Holmes on September 24, 2001 7:31 PM
I have a spreadsheet used to input student enroll data. I sum the monthly entries to produce a running total over an entire year. Here is an example:
Month Enrolls Cumulative Enrolls (formula)
1 20 20
2 30 50
3 10 60
4
5
...
The cumulative field has a formula applied to all 12 datapoints to add the current month total to last months cumulative total.
My problem: I want to create a chart using 12 data points for the entire year so the user does not have to expand the series data range every month. How do I prevent the chart from showing data points for months that have not had an actual value entered??