trend chart with cummulative column

[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'.

 

[vandenberg p]

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

 

[Jon Peltier]

Sometimes with diverse data like this it's better to use two charts than to
put one series on the secondary axis. It depends on the objective you have
for making the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[Guest]

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

 

[Tushar Mehta]

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

 

[Guest]

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

 

[Tushar Mehta]

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

 

[Guest]

thanks. exactly what I wanted.

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

 

[Tushar Mehta]

You are welcome.
--
Regards,

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

thanks. exactly what I wanted.

{snip}