Cumulative line on bar chart

  • Thread starter Thread starter Frustratedfemale26
  • Start date Start date
F

Frustratedfemale26

Hi guys, I have been asked by my boss to modify and existing bar chart to
include a target line and a cumulative line, I have no idea how to do this,
does anyone have any ideas?

Thanks
 
Target line: see http://peltiertech.com/WordPress/add-a-target-line/

Cumulative:
suppose your data is in B2;B20
in C2 enter =B2
in C2 enter =C2+b3 and copy down to row 20
Select C2:C20 and Copy
Click the chart; use Edit | Paste Special with New Series specified
You may bee to right click the new series in the chart and format it to be
on a secondary axis

If Boss is going to make these demands often, you might want to get up to
speed with Excel. I recommend Excel for Dummies (or my Business book - see
my website)
best wishes
 
Back
Top