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?

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