Re: Changing chart types with series

Don't use the built in custom type. Make the chart with all of one type,
like columns, then select one series, and use Chart menu > Chart Type to
change it to another type, like line.

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


"miteeka" <miteeka@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DBBAF7A-D058-4318-8E50-DF54AF2F95CF@xxxxxxxxxxxxxxxx
But how do I automatically turn the second bar graph into a line graph?
This
will give me 1 bar graph and 3 line graphs in total. Thanks,
--
miteeka


"Jon Peltier" wrote:

Sounds like one column is on the primary and the other is on the
secondary
axis. You need some dummy column series that are hidden but still take up
space to push the visible columns into alignment:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

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


"miteeka" <miteeka@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70B45043-9913-452A-AA3B-2D5CDA4456A1@xxxxxxxxxxxxxxxx
Hi,

I currently have a graph comprised of 4 different series. 2 of the
series
are bar graphs, 2 others are line graphs. The problem is that one of
the
bar
graphs is overtop of the other bar graph meaning I can't see that
series.
I've tried going in and changing it by changing the overlapped bar
graph
to a
line graph but I can't seem to do it. I've right clicked, selected
chart
types but I can't change only 1 series of the graph. Is there anyway to
do
this? Thanks,
--
miteeka





.

Relevant Pages

  • Re: Chart wizard funcitonality in Excel 2007?
    ... myself making the same bar graph with a secondary axis line graph. ... I've been using Excel for ... Chart Options substitute as an add-in, just to regain some of my lost speed. ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... of the chart, and a description of the problem, someone may be able to help. ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ... Are the values that were plotted on the horizontal axis now ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... "Jon Peltier" wrote: ... of the chart, and a description of the problem, someone may be able to ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • RE: Insert graph with macro
    ... I just want the graph in the document that I’m ... that could be used to create the chart from. ... manipulated after inserting the chart. ... Dim o_OLE As Word.OLEFormat ...
    (microsoft.public.word.vba.general)