Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change data Series from a bar to a line after changing axis Aaron Charts and Charting in Excel 1 August 17th 07 03:11 AM
Adding more series to 2 axis line graph kate Excel Discussion (Misc queries) 2 February 2nd 07 07:38 PM
Line Graph: Differences between series chinois Charts and Charting in Excel 2 January 4th 06 01:36 AM
Add series to line graph Barb Charts and Charting in Excel 4 December 8th 05 05:07 PM
How do I add one line series to a bar graph? Elliott Charts and Charting in Excel 1 July 13th 05 08:37 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"