|
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another
I would like to develop an Excel Chart with the following data. I have a
chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
In the chart below, the 10 50 and 100 values and $ volume should be on the
right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
John,
I believe you want a combination chart with a primary and secondary Y-axis. In step number one of the chart wizard, go to the Custom Types tab and scroll down the dialog box until you see the combination chart choices. They a Line-Column on Two Axis Lines on Two Axis ---- Regards, John Mansfield http://www.pdbook.com "John Smith" wrote: In the chart below, the 10 50 and 100 values and $ volume should be on the right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
It's better not to rely on the limited choices Excel provides. Make a Line chart
with both series. Double click on the dollar volume series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Mansfield wrote: John, I believe you want a combination chart with a primary and secondary Y-axis. In step number one of the chart wizard, go to the Custom Types tab and scroll down the dialog box until you see the combination chart choices. They a Line-Column on Two Axis Lines on Two Axis ---- Regards, John Mansfield http://www.pdbook.com "John Smith" wrote: In the chart below, the 10 50 and 100 values and $ volume should be on the right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
Thanks - I tried the "Line-Column on Two Axis" and it worked.
But the color scheme is ugly. I would like to simply get rid of the legend, which is easy, and change the bars to different colors, insead of one color. Can this be done? -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Mansfield" wrote in message ... John, I believe you want a combination chart with a primary and secondary Y-axis. In step number one of the chart wizard, go to the Custom Types tab and scroll down the dialog box until you see the combination chart choices. They a Line-Column on Two Axis Lines on Two Axis ---- Regards, John Mansfield http://www.pdbook.com "John Smith" wrote: In the chart below, the 10 50 and 100 values and $ volume should be on the right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
If you want to change individual bar colors, you can select the bar you want
to change and change the color scheme. If you want RED to mean one thing and YELLOW to mean something else for different X axis labels (and you have a lot to change), it might be better to have a "STACKED COLUMN" chart with line for the secondary axis information. "John Smith" wrote in message news:BtZxd.611264$D%.467476@attbi_s51... Thanks - I tried the "Line-Column on Two Axis" and it worked. But the color scheme is ugly. I would like to simply get rid of the legend, which is easy, and change the bars to different colors, insead of one color. Can this be done? -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Mansfield" wrote in message ... John, I believe you want a combination chart with a primary and secondary Y-axis. In step number one of the chart wizard, go to the Custom Types tab and scroll down the dialog box until you see the combination chart choices. They a Line-Column on Two Axis Lines on Two Axis ---- Regards, John Mansfield http://www.pdbook.com "John Smith" wrote: In the chart below, the 10 50 and 100 values and $ volume should be on the right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
The chart where I have the challenge is "stacked column with 3D visual
effect". There are two series, but the checkbox for series (Y) axis is grayed out. There does not appear to be a way to add a secondary y axis to this type of chart. I have a different set of dialog box options for the Line-Column on Two Axis" chart. It is has the line w/the second set of data points scaling the bars. It would look much better three dimensionally. Is there are a way to add an extra axis to the "stacked column with 3D visual effect"? -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "Barb Reinhardt" wrote in message ... If you want to change individual bar colors, you can select the bar you want to change and change the color scheme. If you want RED to mean one thing and YELLOW to mean something else for different X axis labels (and you have a lot to change), it might be better to have a "STACKED COLUMN" chart with line for the secondary axis information. "John Smith" wrote in message news:BtZxd.611264$D%.467476@attbi_s51... Thanks - I tried the "Line-Column on Two Axis" and it worked. But the color scheme is ugly. I would like to simply get rid of the legend, which is easy, and change the bars to different colors, insead of one color. Can this be done? -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Mansfield" wrote in message ... John, I believe you want a combination chart with a primary and secondary Y-axis. In step number one of the chart wizard, go to the Custom Types tab and scroll down the dialog box until you see the combination chart choices. They a Line-Column on Two Axis Lines on Two Axis ---- Regards, John Mansfield http://www.pdbook.com "John Smith" wrote: In the chart below, the 10 50 and 100 values and $ volume should be on the right. $ volume 10 50 100 -- -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com "John Smith" wrote in message news:lrXxd.234405$V41.22788@attbi_s52... I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com |
John -
That's another good reason for sticking with a 2D chart. A line series never looks very good in 3D, and any 2D charts represented with a false third dimension introduces uncertainty in the values being charted. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ John Smith wrote: The chart where I have the challenge is "stacked column with 3D visual effect". There are two series, but the checkbox for series (Y) axis is grayed out. There does not appear to be a way to add a secondary y axis to this type of chart. I have a different set of dialog box options for the Line-Column on Two Axis" chart. It is has the line w/the second set of data points scaling the bars. It would look much better three dimensionally. Is there are a way to add an extra axis to the "stacked column with 3D visual effect"? |
| All times are GMT +1. The time now is 03:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com