trend chart with cummulative column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i would like to plot a chart that has combination of column trend chart, goal
line chart and a cummulative column chart.

Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200

Goal = 1500 for Jan to Dec
YTD= Year to date

If I use the same axis for the column trend chart and YTD column chart, the
chart will be lobsided with YTD column so 'tall'.
 
Hello:

Plot the YTD on the secondary (right) axis).

Pieter Vandenberg

: i would like to plot a chart that has combination of column trend chart, goal
: line chart and a cummulative column chart.

: Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200

: Goal = 1500 for Jan to Dec
: YTD= Year to date

: If I use the same axis for the column trend chart and YTD column chart, the
: chart will be lobsided with YTD column so 'tall'.
 
Basically I want to show how the assembly perform actual by month against the
monthly goal (1500). At the same time what is the YTD number. As the YTD is
the cummulative of 12 months obviously it will be much higher. Using the same
axis, the YTD column bar will dwarf the monthly column number.

How can I plot the YTD on the secondary (right) axis?.
 
On the chart, double-click the YTD series. From the Axis tab, select
Secondary axis.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
when i double click ytd column there is only pattern, data labels and option
to select. actually there is no YTD series but just a column YTD. the YTD
series is part of the monthly series.

Jan=1000
Feb=1500
Mar=1200
Apr=1500
May=1200
Jun=1000
Jul=1500
Aug=1400
Sep=1450
Oct=1250
Nov=1100
Dec=1200
YTD=15300
 
Add another column with all empty cells except the last one, which will
contain YTD data. [In the first, monthly series, leave the last cell empty.]

Add this new column as a 2nd series to the chart.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
thanks. exactly what I wanted.

Tushar Mehta said:
Add another column with all empty cells except the last one, which will
contain YTD data. [In the first, monthly series, leave the last cell empty.]

Add this new column as a 2nd series to the chart.

--
Regards,

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

when i double click ytd column there is only pattern, data labels and option
to select. actually there is no YTD series but just a column YTD. the YTD
series is part of the monthly series.

Jan=1000
Feb=1500
Mar=1200
Apr=1500
May=1200
Jun=1000
Jul=1500
Aug=1400
Sep=1450
Oct=1250
Nov=1100
Dec=1200
YTD=15300
Click to expand...
Click to expand...
 
Back
Top