| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combination charts: two variables in one series?
I want to plot density (y) and shrinkage (y) vs. temperature (x axis) but
Excel 2003 gives me two lines on a combination chart because the Y axes are fixed. Can I have one of the y axes adjust to give only one line? Also when I reverse the values of density the temperature goes to the top of the graph instead of staying at the bottom. Is all of this possible in Excel? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
combination charts: two variables in one series?
Hi,
To keep the x axis label at the bottom you also need to check the "Category (x) axis crosses at maximum value" option, which is also on the scale tab. Have you selected the shrinkage series and on the format dialog set the axis to secondary? Cheers Andy Bob with Q wrote: I want to plot density (y) and shrinkage (y) vs. temperature (x axis) but Excel 2003 gives me two lines on a combination chart because the Y axes are fixed. Can I have one of the y axes adjust to give only one line? Also when I reverse the values of density the temperature goes to the top of the graph instead of staying at the bottom. Is all of this possible in Excel? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel charts should allow "switching" series on or off | Charts and Charting in Excel | |||
| Disappearing scales on bar charts with multiple series | Charts and Charting in Excel | |||
| How do I alter the number of bar series in a combination chart? | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Linear Mode
