Step change charts

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.
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top