software

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

chiuinggum gt; wrote:
: 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'.

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;chiuinggumquot; gt; wrote in message
...
gt;i would like to plot a chart that has combination of column trend chart,
gt;goal
gt; line chart and a cummulative column chart.
gt;
gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt;
gt; Goal = 1500 for Jan to Dec
gt; YTD= Year to date
gt;
gt; If I use the same axis for the column trend chart and YTD column chart,
gt; the
gt; 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?.
quot;Jon Peltierquot; wrote:

gt; Sometimes with diverse data like this it's better to use two charts than to
gt; put one series on the secondary axis. It depends on the objective you have
gt; for making the chart.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;chiuinggumquot; gt; wrote in message
gt; ...
gt; gt;i would like to plot a chart that has combination of column trend chart,
gt; gt;goal
gt; gt; line chart and a cummulative column chart.
gt; gt;
gt; gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt; gt;
gt; gt; Goal = 1500 for Jan to Dec
gt; gt; YTD= Year to date
gt; gt;
gt; gt; If I use the same axis for the column trend chart and YTD column chart,
gt; gt; the
gt; gt; chart will be lobsided with YTD column so 'tall'.
gt;
gt;
gt;

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

In article gt;,says...
gt; Basically I want to show how the assembly perform actual by month against the
gt; monthly goal (1500). At the same time what is the YTD number. As the YTD is
gt; the cummulative of 12 months obviously it will be much higher. Using the same
gt; axis, the YTD column bar will dwarf the monthly column number.
gt;
gt; How can I plot the YTD on the secondary (right) axis?.
gt;
gt;
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt; gt; Sometimes with diverse data like this it's better to use two charts than to
gt; gt; put one series on the secondary axis. It depends on the objective you have
gt; gt; for making the chart.
gt; gt;
gt; gt; - Jon
gt; gt; -------
gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt; PeltierTech.com/
gt; gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt; _______
gt; gt;
gt; gt; quot;chiuinggumquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;i would like to plot a chart that has combination of column trend chart,
gt; gt; gt;goal
gt; gt; gt; line chart and a cummulative column chart.
gt; gt; gt;
gt; gt; gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt; gt; gt;
gt; gt; gt; Goal = 1500 for Jan to Dec
gt; gt; gt; YTD= Year to date
gt; gt; gt;
gt; gt; gt; If I use the same axis for the column trend chart and YTD column chart,
gt; gt; gt; the
gt; gt; gt; chart will be lobsided with YTD column so 'tall'.
gt; gt;
gt; gt;
gt; gt;
gt;

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

quot;Tushar Mehtaquot; wrote:

gt; On the chart, double-click the YTD series. From the Axis tab, select
gt; Secondary axis.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt; gt; Basically I want to show how the assembly perform actual by month against the
gt; gt; monthly goal (1500). At the same time what is the YTD number. As the YTD is
gt; gt; the cummulative of 12 months obviously it will be much higher. Using the same
gt; gt; axis, the YTD column bar will dwarf the monthly column number.
gt; gt;
gt; gt; How can I plot the YTD on the secondary (right) axis?.
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Jon Peltierquot; wrote:
gt; gt;
gt; gt; gt; Sometimes with diverse data like this it's better to use two charts than to
gt; gt; gt; put one series on the secondary axis. It depends on the objective you have
gt; gt; gt; for making the chart.
gt; gt; gt;
gt; gt; gt; - Jon
gt; gt; gt; -------
gt; gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt; gt; PeltierTech.com/
gt; gt; gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt; gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt; gt; _______
gt; gt; gt;
gt; gt; gt; quot;chiuinggumquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;i would like to plot a chart that has combination of column trend chart,
gt; gt; gt; gt;goal
gt; gt; gt; gt; line chart and a cummulative column chart.
gt; gt; gt; gt;
gt; gt; gt; gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt; gt; gt; gt;
gt; gt; gt; gt; Goal = 1500 for Jan to Dec
gt; gt; gt; gt; YTD= Year to date
gt; gt; gt; gt;
gt; gt; gt; gt; If I use the same axis for the column trend chart and YTD column chart,
gt; gt; gt; gt; the
gt; gt; gt; gt; chart will be lobsided with YTD column so 'tall'.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt;

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

In article gt;,says...
gt; when i double click ytd column there is only pattern, data labels and option
gt; to select. actually there is no YTD series but just a column YTD. the YTD
gt; series is part of the monthly series.
gt;
gt; Jan=1000
gt; Feb=1500
gt; Mar=1200
gt; Apr=1500
gt; May=1200
gt; Jun=1000
gt; Jul=1500
gt; Aug=1400
gt; Sep=1450
gt; Oct=1250
gt; Nov=1100
gt; Dec=1200
gt; YTD=15300
gt;
gt; quot;Tushar Mehtaquot; wrote:
gt;
gt; gt; On the chart, double-click the YTD series. From the Axis tab, select
gt; gt; Secondary axis.
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Tushar Mehta
gt; gt; www.tushar-mehta.com
gt; gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; gt; Custom MS Office productivity solutions
gt; gt;
gt; gt; In article gt;,
gt; gt; says...
gt; gt; gt; Basically I want to show how the assembly perform actual by month against the
gt; gt; gt; monthly goal (1500). At the same time what is the YTD number. As the YTD is
gt; gt; gt; the cummulative of 12 months obviously it will be much higher. Using the same
gt; gt; gt; axis, the YTD column bar will dwarf the monthly column number.
gt; gt; gt;
gt; gt; gt; How can I plot the YTD on the secondary (right) axis?.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Jon Peltierquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Sometimes with diverse data like this it's better to use two charts than to
gt; gt; gt; gt; put one series on the secondary axis. It depends on the objective you have
gt; gt; gt; gt; for making the chart.
gt; gt; gt; gt;
gt; gt; gt; gt; - Jon
gt; gt; gt; gt; -------
gt; gt; gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt; gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt; gt; gt; PeltierTech.com/
gt; gt; gt; gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt; gt; gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt; gt; gt; _______
gt; gt; gt; gt;
gt; gt; gt; gt; quot;chiuinggumquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;i would like to plot a chart that has combination of column trend chart,
gt; gt; gt; gt; gt;goal
gt; gt; gt; gt; gt; line chart and a cummulative column chart.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Goal = 1500 for Jan to Dec
gt; gt; gt; gt; gt; YTD= Year to date
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; If I use the same axis for the column trend chart and YTD column chart,
gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; chart will be lobsided with YTD column so 'tall'.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt;
gt; gt;
gt;

thanks. exactly what I wanted.

quot;Tushar Mehtaquot; wrote:

gt; Add another column with all empty cells except the last one, which will
gt; contain YTD data. [In the first, monthly series, leave the last cell empty.]
gt;
gt; Add this new column as a 2nd series to the chart.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt; gt; when i double click ytd column there is only pattern, data labels and option
gt; gt; to select. actually there is no YTD series but just a column YTD. the YTD
gt; gt; series is part of the monthly series.
gt; gt;
gt; gt; Jan=1000
gt; gt; Feb=1500
gt; gt; Mar=1200
gt; gt; Apr=1500
gt; gt; May=1200
gt; gt; Jun=1000
gt; gt; Jul=1500
gt; gt; Aug=1400
gt; gt; Sep=1450
gt; gt; Oct=1250
gt; gt; Nov=1100
gt; gt; Dec=1200
gt; gt; YTD=15300
gt; gt;
gt; gt; quot;Tushar Mehtaquot; wrote:
gt; gt;
gt; gt; gt; On the chart, double-click the YTD series. From the Axis tab, select
gt; gt; gt; Secondary axis.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Tushar Mehta
gt; gt; gt; www.tushar-mehta.com
gt; gt; gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; gt; gt; Custom MS Office productivity solutions
gt; gt; gt;
gt; gt; gt; In article gt;,
gt; gt; gt; says...
gt; gt; gt; gt; Basically I want to show how the assembly perform actual by month against the
gt; gt; gt; gt; monthly goal (1500). At the same time what is the YTD number. As the YTD is
gt; gt; gt; gt; the cummulative of 12 months obviously it will be much higher. Using the same
gt; gt; gt; gt; axis, the YTD column bar will dwarf the monthly column number.
gt; gt; gt; gt;
gt; gt; gt; gt; How can I plot the YTD on the secondary (right) axis?.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Jon Peltierquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sometimes with diverse data like this it's better to use two charts than to
gt; gt; gt; gt; gt; put one series on the secondary axis. It depends on the objective you have
gt; gt; gt; gt; gt; for making the chart.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; - Jon
gt; gt; gt; gt; gt; -------
gt; gt; gt; gt; gt; Jon Peltier, Microsoft Excel MVP
gt; gt; gt; gt; gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; gt; gt; gt; gt; PeltierTech.com/
gt; gt; gt; gt; gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; gt; gt; gt; gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; gt; gt; gt; gt; _______
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;chiuinggumquot; gt; wrote in message
gt; gt; gt; gt; gt; ...
gt; gt; gt; gt; gt; gt;i would like to plot a chart that has combination of column trend chart,
gt; gt; gt; gt; gt; gt;goal
gt; gt; gt; gt; gt; gt; line chart and a cummulative column chart.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Jan=1000/Feb=1500/Mar=1200/Apr=1500/May=1200/Jun=1000/Jul=1500/Aug=1400/Sep=1450/Oct=1250/Nov=1100/Dec=1200
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Goal = 1500 for Jan to Dec
gt; gt; gt; gt; gt; gt; YTD= Year to date
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; If I use the same axis for the column trend chart and YTD column chart,
gt; gt; gt; gt; gt; gt; the
gt; gt; gt; gt; gt; gt; chart will be lobsided with YTD column so 'tall'.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt;
gt; gt;
gt;

You are welcome.
--
Regards,

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

In article gt;,says...
gt; thanks. exactly what I wanted.
gt;
{snip}