Changing chart types with series
 

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

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/...OnTwoAxes.html

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


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

Changing chart types with series
 

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/...OnTwoAxes.html

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


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

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" wrote in message
...
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/...OnTwoAxes.html

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


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