|
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'. |
trend chart with cummulative column
Hello:
Plot the YTD on the secondary (right) axis). Pieter Vandenberg chiuinggum 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'. |
trend chart with cummulative column
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" wrote in message ... 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'. |
trend chart with cummulative column
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" wrote in message ... 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'. |
trend chart with cummulative column
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 , 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" wrote in message ... 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'. |
trend chart with cummulative column
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 , 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 , 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" wrote in message ... 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'. |
trend chart with cummulative column
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 , 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 , 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" wrote in message ... 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'. |
trend chart with cummulative column
You are welcome.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... thanks. exactly what I wanted. {snip} |
| All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com