hiding unused categories in charts

[Guest]

Hi - I'm convinced there is an easy and automated answer to my excel problem
and would appreciate user feedback.

The issue: I've created a chart that is supposed to show YTD values
(employee terminations) for each month of the year. At the beginning of the
year we do not have data for the later months (because those months haven't
happened yet.)

What I want: For the chart to show only those months for which it has data
and to not take up page space for months where this is no data. In other
words, as the year progresses the chart should automatically expant to
include the new data, without me have to fuss with the chart's source data
each month.

Any ideas on how to solve this problem in Excel 2003?

 

[Gord Dibben]

Use a Dynamic range for the series that will expand as the data grows over the
months.

See Tushar Mehta's site for instructions. Item #1 at this page.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html


Gord Dibben MS Excel MVP

On Mon, 19 Mar 2007 13:51:05 -0700, Compensation Analyst <Compensation