| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a stacked bar, line combination chart | Charts and Charting in Excel | |||
| How do I create a combination chart and table with different data. | Charts and Charting in Excel | |||
| Combination Chart | Charts and Charting in Excel | |||
| Problems with X Axis for a Line Chart | Charts and Charting in Excel | |||
| Vertical ND Curve on Combination Chart | Charts and Charting in Excel | |||
Linear Mode
