| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar chart with XY on secondary axis
I have four quarters of data that I display as a bar chart. I want to add
additional data superimposed on each (XY) as a secondary axis. However, the XY coordinates are displayed on a single vertical axis in the center of the bars rather than on each related bar. Data: (BAR) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 7.1 2.3 4.5 8.7 B 10.5 1.5 6.7 4.8 C 14.6 4.0 7.9 11.1 (XY) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 25 55 67 23 B 18 44 122 98 C 5 11 104 45 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with XY on secondary axis
Hi,
By bar I assume you mean Column and XY you mean Line, or XY without specifying the X values. Anyway here is how to over come the problem. http://peltiertech.com/Excel/Charts/...olAndLine.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "casey" wrote in message ... I have four quarters of data that I display as a bar chart. I want to add additional data superimposed on each (XY) as a secondary axis. However, the XY coordinates are displayed on a single vertical axis in the center of the bars rather than on each related bar. Data: (BAR) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 7.1 2.3 4.5 8.7 B 10.5 1.5 6.7 4.8 C 14.6 4.0 7.9 11.1 (XY) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 25 55 67 23 B 18 44 122 98 C 5 11 104 45 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bar chart with XY on secondary axis
Yes and Yes. :-)
And I can say by looking at the final chart on this (Peltier's) link that this will work perfectly for what I needed! Thanks, Andy. Casey "Andy Pope" wrote: Hi, By bar I assume you mean Column and XY you mean Line, or XY without specifying the X values. Anyway here is how to over come the problem. http://peltiertech.com/Excel/Charts/...olAndLine.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "casey" wrote in message ... I have four quarters of data that I display as a bar chart. I want to add additional data superimposed on each (XY) as a secondary axis. However, the XY coordinates are displayed on a single vertical axis in the center of the bars rather than on each related bar. Data: (BAR) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 7.1 2.3 4.5 8.7 B 10.5 1.5 6.7 4.8 C 14.6 4.0 7.9 11.1 (XY) 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr A 25 55 67 23 B 18 44 122 98 C 5 11 104 45 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Secondary Axis chart | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Hybrid Mode
