| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problem with Column Chart on 2 Axis
I have two series, A and B, and 3 values for each series. When I create a
side by side column chart, right click the second series and choose Format Data Series Axis Secondary the two series overlap in one space; why did I lose the side by side appearance and how might I get it back? TIA for any ideas. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Column Chart on 2 Axis
Excel effectively treats the two series as two independent charts. If you
still want the series side by side, make dummy series and make these transparent without borders so you don't see it effectively. Change the series order as appropriate. GL, Henk "headly" wrote: I have two series, A and B, and 3 values for each series. When I create a side by side column chart, right click the second series and choose Format Data Series Axis Secondary the two series overlap in one space; why did I lose the side by side appearance and how might I get it back? TIA for any ideas. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Problem with Column Chart on 2 Axis
Here's an illustrated example:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "HEK" wrote in message ... Excel effectively treats the two series as two independent charts. If you still want the series side by side, make dummy series and make these transparent without borders so you don't see it effectively. Change the series order as appropriate. GL, Henk "headly" wrote: I have two series, A and B, and 3 values for each series. When I create a side by side column chart, right click the second series and choose Format Data Series Axis Secondary the two series overlap in one space; why did I lose the side by side appearance and how might I get it back? TIA for any ideas. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Category axis label problem at column chart | Charts and Charting in Excel | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| combination x-y scatter and column graph | Charts and Charting in Excel | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Linear Mode
