If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dual Axis stacked bar.
Hello,
Thank you in advance for any and all the help. I have 4 sets of data. I have: The date which i want to be on the X-Axis I have two $ values that i want stacked in a bar chart with the $ number on the left Y-Axis And finally i have the % value which will be shown on the right Y-Axis but as a line chart. Can this be done and how? Again, thank you. |
#2
|
|||
|
|||
Hi,
Easiest way is to create a stacked bar chart using the 3 sets of data and then format the 3rd data series to be on the secondary axis with a chart style of line. So for example your 4 sets of data are in the range A113. B11 contains series names A2:A13 contains 12 months B2:B13 contains bottom of stack data C2:C13 contains top of stack data D213 contains %Value data Select the range A113 and create a stacked bar chart using the wizard. Double click the %value data series and on the axis tab select the secondary axis. This time right click the %Value data series and change the chart type to line. Cheers Andy Interactive worksheet wrote: Hello, Thank you in advance for any and all the help. I have 4 sets of data. I have: The date which i want to be on the X-Axis I have two $ values that i want stacked in a bar chart with the $ number on the left Y-Axis And finally i have the % value which will be shown on the right Y-Axis but as a line chart. Can this be done and how? Again, thank you. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stacked Bar Chart with Secondary Axis | Benjamin B | Charts and Charting | 7 | May 15th, 2005 04:00 AM |
Create stacked columns chart but with 2 columns for each x axis? | PSM | Charts and Charting | 2 | May 7th, 2005 03:56 PM |
Stacked Bar and 2nd Axis w/ Line - Excel 2003 | Doug | Charts and Charting | 2 | April 17th, 2004 06:01 PM |
Stacked Charts with price on 2nd axis | Tushar Mehta | Charts and Charting | 1 | December 19th, 2003 01:52 PM |
data to chart on primary axis | jw | Charts and Charting | 6 | September 24th, 2003 12:46 AM |