trend chart with cummulative column

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

"chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
>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?.



"Jon Peltier" wrote:

> 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
> _______
>
> "chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
> news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
> >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'.
>
>
>

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 <0069EC71-B71C-4D1E-875E-499464D50BFA@microsoft.com>,
chiuinggum@discussions.microsoft.com says...
> 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?.
>
>
>
> "Jon Peltier" wrote:
>
> > 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
> > _______
> >
> > "chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
> > news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
> > >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'.
> >
> >
> >
>

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" wrote:

> 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 <0069EC71-B71C-4D1E-875E-499464D50BFA@microsoft.com>,
> chiuinggum@discussions.microsoft.com says...
> > 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?.
> >
> >
> >
> > "Jon Peltier" wrote:
> >
> > > 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
> > > _______
> > >
> > > "chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
> > > news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
> > > >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'.
> > >
> > >
> > >
> >
>

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 <D35C4268-A38E-4CB6-9417-91520A57DD02@microsoft.com>,
chiuinggum@discussions.microsoft.com says...
> 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" wrote:
>
> > 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 <0069EC71-B71C-4D1E-875E-499464D50BFA@microsoft.com>,
> > chiuinggum@discussions.microsoft.com says...
> > > 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?.
> > >
> > >
> > >
> > > "Jon Peltier" wrote:
> > >
> > > > 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
> > > > _______
> > > >
> > > > "chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
> > > > news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
> > > > >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'.
> > > >
> > > >
> > > >
> > >
> >
>

thanks. exactly what I wanted.

"Tushar Mehta" wrote:

> 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 <D35C4268-A38E-4CB6-9417-91520A57DD02@microsoft.com>,
> chiuinggum@discussions.microsoft.com says...
> > 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" wrote:
> >
> > > 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 <0069EC71-B71C-4D1E-875E-499464D50BFA@microsoft.com>,
> > > chiuinggum@discussions.microsoft.com says...
> > > > 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?.
> > > >
> > > >
> > > >
> > > > "Jon Peltier" wrote:
> > > >
> > > > > 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
> > > > > _______
> > > > >
> > > > > "chiuinggum" <chiuinggum@discussions.microsoft.com> wrote in message
> > > > > news:B34D6467-1AA6-4679-B66E-2FC129D45195@microsoft.com...
> > > > > >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'.
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>

You are welcome.
--
Regards,

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

In article <04DBEFCE-057A-41F0-898E-86BBD3E2DF78@microsoft.com>,
chiuinggum@discussions.microsoft.com says...
> thanks. exactly what I wanted.
>
{snip}