combination chart problems
 

I am trying to creat a Excel combination chart using two existing charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on the
new series and choosing line type chart for this series. When I click okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna

combination chart problems
 

Unreadable because the two data series have very different ranges?
How about using a secondary y-axis?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jo Anna" wrote in message
...
I am trying to creat a Excel combination chart using two existing charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on the
new series and choosing line type chart for this series. When I click okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna

combination chart problems
 

Bernard,
No the ranges are the very similar.
secondary y-axis When I dbl click on the series I get a "Format Data
Series"
with no Axis tab.
--
Jo Anna


"Jo Anna" wrote:

I am trying to creat a Excel combination chart using two existing charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on the
new series and choosing line type chart for this series. When I click okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna

combination chart problems
 

What kind of chart is it? Some kinds of charts do not combine with others,
types like surface/contour charts and charts with 3D effects. (Another of
the 47 reasons to avoid 3D effects.)

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


"Jo Anna" wrote in message
...
Bernard,
No the ranges are the very similar.
secondary y-axis When I dbl click on the series I get a "Format Data
Series"
with no Axis tab.
--
Jo Anna


"Jo Anna" wrote:

I am trying to creat a Excel combination chart using two existing charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on
the
new series and choosing line type chart for this series. When I click
okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna

combination chart problems
 

Jon,
They are column and line charts.
--
Jo Anna


"Jon Peltier" wrote:

What kind of chart is it? Some kinds of charts do not combine with others,
types like surface/contour charts and charts with 3D effects. (Another of
the 47 reasons to avoid 3D effects.)

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


"Jo Anna" wrote in message
...
Bernard,
No the ranges are the very similar.
secondary y-axis When I dbl click on the series I get a "Format Data
Series"
with no Axis tab.
--
Jo Anna


"Jo Anna" wrote:

I am trying to creat a Excel combination chart using two existing charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on
the
new series and choosing line type chart for this series. When I click
okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna

combination chart problems
 

With 3D effects? These have no Axis tab in the Format Series dialog.

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


"Jo Anna" wrote in message
...
Jon,
They are column and line charts.
--
Jo Anna


"Jon Peltier" wrote:

What kind of chart is it? Some kinds of charts do not combine with
others,
types like surface/contour charts and charts with 3D effects. (Another of
the 47 reasons to avoid 3D effects.)

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


"Jo Anna" wrote in message
...
Bernard,
No the ranges are the very similar.
secondary y-axis When I dbl click on the series I get a "Format
Data
Series"
with no Axis tab.
--
Jo Anna


"Jo Anna" wrote:

I am trying to creat a Excel combination chart using two existing
charts.
What is the easiest way to do this? I have tried to add data to one
chart(column type) thereby creating a new series and right clicking on
the
new series and choosing line type chart for this series. When I click
okay
the line chart is visible but the rest of the data is unreadable.
--
Jo Anna