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


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.
 
Ad

Advertisements

J

Jon Peltier

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

Top