Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting a full year without zeros
Help! I want to chart results for the coming year where the data feeds in month-by-month. The problem is that the chart pluges to zero for the future months. How do I terminate the data at the current point (January to September) without having to reset the data ranges every month? Thanks -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=470385 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Year scale | Charts and Charting in Excel | |||
Charting with zeros or DIV/0 values | Charts and Charting in Excel | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
Calculating commission schedule (will pay for help!) | Excel Worksheet Functions |