Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2nd Axes - primary series data of only 1 series disappears!
I have a chart with 4 (2 lines & 2 bars) series of data, 3 (2 lines & 1
bar)referencing the primary axis and the other bar is supposed to reference the secondary axis. When I format this series, the primary bar series overlaps the 2nd bar series - they should be 2 separate bar graphs. How do I fix this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2nd Axes - primary series data of only 1 series disappears!
You need to use some hidden column series to keep the visible columns from
overlapping: http://peltiertech.com/Excel/Charts/...OnTwoAxes.html Do the columns first, then add the line chart data, and convert them to line series (Excel will add them as columns). To change them, and make your own custom combination chart, select a series, and on the Chart menu, use Chart Type to select an appropriate line chart style. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "cheriw" wrote in message ... I have a chart with 4 (2 lines & 2 bars) series of data, 3 (2 lines & 1 bar)referencing the primary axis and the other bar is supposed to reference the secondary axis. When I format this series, the primary bar series overlaps the 2nd bar series - they should be 2 separate bar graphs. How do I fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
farmating a data series | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |