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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart -- Source Data... -- Series dialog window | Sarah Jane | Charts and Charting | 2 | January 24th, 2006 10:27 AM |
I need more general XY point to point plotting than XY scatter in | spazminator | Charts and Charting | 12 | December 19th, 2005 05:00 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |
Having both the date and total of series data displayed underthe data | Jon Peltier | Charts and Charting | 0 | April 14th, 2004 08:39 PM |