Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding unused categories in charts
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
After hiding unused columns to the right, border on right disappea | Excel Discussion (Misc queries) | |||
making charts based on text categories | Excel Discussion (Misc queries) | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel |