![]() |
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 |
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