Changing a data series in a graph from a line to a bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

japc90 - 20 Mar 2008 15:27 GMT

I created a graph with a dual axis. I want the first three data sets
to go off of the first axis and the fourth to go of the second axis. I
was able to do this but I also want the first three to be bars and the
fourth to be a line. The graph is austomatically making the first two
bars and the second two lines. How can I change the lines?

I appreciate all assistance

Reply to this Message

Jon Peltier - 20 Mar 2008 17:20 GMT

Next time ignore the inflexible built-in chart types. Make your chart with
one kind of series, then select each that you want to change, go to Chart
menu > Chart Type, and pick the type you want. Later you can double click
each you want on a secondary axis, and change the axis on the axis tab.

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

>I created a graph with a dual axis. I want the first three data sets
> to go off of the first axis and the fourth to go of the second axis. I
[quoted text clipped - 3 lines]
>
> I appreciate all assistance

Reply to this Message