| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Charts
Im using an IF formula for percentages based on sales data. Future months(no
data to calculate yet) show blank but in a chart it shows as a huge downward line continuing at the zero line until dec 05. Can you make the chart not do that, without adjusting the data table every month? |
|
#2
|
|||
|
|||
|
Jon Peltier has information on dynamic charts that may help you:
http://www.peltiertech.com/Excel/Charts/Dynamics.html chrisandfarah wrote: Im using an IF formula for percentages based on sales data. Future months(no data to calculate yet) show blank but in a chart it shows as a huge downward line continuing at the zero line until dec 05. Can you make the chart not do that, without adjusting the data table every month? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charts won't update | Charts and Charting in Excel | |||
| Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
| linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
Linear Mode
