Step change charts

  • Thread starter Thread starter Paul Johnson
  • Start date Start date
P

Paul Johnson

Help,

I am trying to create a bar charts by year but only want
to show increases and decreases through the middle years
as step changes i.e.

1999 100

2000 +10
2001 -30
2002 +40

2003 120

How can I do this? What I should see is the first vertical
bar being 100 then from the 100 level an increase of 10 to
get to 110 then a decrease bar of -30 (from the 110 level)
to get to 80 etc etc.
 
For a tutorial, see the Excel | Charts | Waterfall Chart page of my web
site.
--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top