Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I hide part of a data series in a chart?
We have a chart with 2 data series - Budget & Actual. We want to show all 12
months of the budget, but only the year-to-date months of the actual. The problem is the data cells for the future actual amounts have formulas in them so the chart use the result and plots the line. We do not want to delete the data (which will require manual input each month, we just want the actual data series line to not show for the future periods. We tried using IF statements with 0, "", " " and an alpha character, but these have not worked. -- Jeff |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I hide part of a data series in a chart?
Hi Jeff:
You can set up your actual data as a dynamic named range series, using the OFFSET function. Many MVPs give tutorials how to do this on their websites, see for instance: http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/e...ps.htm#Dynamic http://peltiertech.com/Excel/Charts/Dynamics.html http://www.contextures.com/xlNames02.html GL, Henk "Jeff Bremer" wrote: We have a chart with 2 data series - Budget & Actual. We want to show all 12 months of the budget, but only the year-to-date months of the actual. The problem is the data cells for the future actual amounts have formulas in them so the chart use the result and plots the line. We do not want to delete the data (which will require manual input each month, we just want the actual data series line to not show for the future periods. We tried using IF statements with 0, "", " " and an alpha character, but these have not worked. -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i use the IF function in a chart to choose its data series? | Charts and Charting in Excel | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |