ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing a data series in a graph from a line to a bar (https://www.excelbanter.com/excel-discussion-misc-queries/180746-changing-data-series-graph-line-bar.html)

japc90

Changing a data series in a graph from a line to a bar
 
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

Jon Peltier

Changing a data series in a graph from a line to a bar
 
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
_______


"japc90" wrote in message
...
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





All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com