Re: Changing chart types with series

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

  • Chart Problems
    ... would set up Population as a bar graph on the primary Y ... Secondary Y axis. ... >I am having problems trying to chart information due to ...
    (microsoft.public.excel.charting)
  • 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: Vertical Lines on the Lines on 2 Axes Chart
    ... I've tried starting with the line graph and adding a bar graph series ... axis' used up. ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: Changing chart types with series
    ... Don't use the built in custom type. ... Make the chart with all of one type, ... will give me 1 bar graph and 3 line graphs in total. ... I currently have a graph comprised of 4 different series. ...
    (microsoft.public.excel.charting)
  • Charting two axes
    ... Revenue $ on left axis using bar graph ... Two Gross Profit % (GAAP and Proforma) on right axis using ... I can only get one bar and one line graph using the custom ...
    (microsoft.public.excel.charting)