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
|
|||
|
|||
2 Axis Charting with Column and Line Formats
I have a 6 series chart, with two axis'. The primary axis is in column format, and the secondary axis is in line format. I want to add a seventh series (plotted on the secondary axis). Excel does this but changes the four series to now be plotted on the primary axis with the column format. I can change the fourth series to be plotted on the secondary axis, however it is still displayed in the column format (and now being plotted in front of, rather than beside the first three series). Excel seems to plot the first half of the series in a column format (which ever axis is on), how can I override this ? |
#2
|
|||
|
|||
2 Axis Charting with Column and Line Formats
Rob -
Sometimes it's easier to build the chart yourself than using one of Excel's built-in combination chart types. Plot all your series on the chart as a column chart. There will be only a primary axis. Select one series you want to be a line style, go to Chart Type on the Chart menu, and change it to a line. In turn, select each of the other series you want to switch, and press F4 to repeat the action. Now double-click one of the line series, and on the Axis tab, select Secondary. In turn, select each of the other line series, and press F4 to repeat the action. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Rob Uter wrote: I have a 6 series chart, with two axis'. The primary axis is in column format, and the secondary axis is in line format. I want to add a seventh series (plotted on the secondary axis). Excel does this but changes the four series to now be plotted on the primary axis with the column format. I can change the fourth series to be plotted on the secondary axis, however it is still displayed in the column format (and now being plotted in front of, rather than beside the first three series). Excel seems to plot the first half of the series in a column format (which ever axis is on), how can I override this ? |
Thread Tools | |
Display Modes | |
|
|