How do I force a series in a Bar-Line Chart to be a Bar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 series in a Bar+Line chart that has multiple Y-Axis and I want 3 of
the series to reference the Primary Y-Axis using a Bar format and 1 of the
series referencing the Secondary Y-Axis using a Line format. Excel seems to
be forcing me to reference 2 series to one Y-Axis and the other 2 to the
other Y-Axis. How can I force it to do what I want... I have been trying
many settings and have not found the magical combination as of yet.
 
Select the series.
Select Chart Type from Chart menu.
Select the type of series you want.

In the future, you may find it easier to use a common chart type, like a Line chart,
and change the series you specifically want to change. Using the built-in custom
types means you are allowing Excel to assume how to format each series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple series bar and line chart 2
vertical scale on both ends of bar chart 1
Moving overlapping bars forwards and backwards 1
Creating a Combination Bar Chart with 2 Lines 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Help with Bar-Line Chart..not aligned?? 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Adding a Second and Third Line to an Existing Stacked Bar/Line Cha 3

Back
Top