| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I not graph a 0 value.
I have a graph that is charting monthly sales over an 8 year period. I have my chart set to automatically update as the future data is entered. My problem is that I want my y axis to show all 8 years and my graph line to stop at the current month and not graph the zero values for the future months. Does anyone know how I can do this? -- jbd ------------------------------------------------------------------------ jbd's Profile: http://www.excelforum.com/member.php...o&userid=35417 View this thread: http://www.excelforum.com/showthread...hreadid=551874 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar graph and line graph overlayed | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
| How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
Threaded Mode
