| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how differentiate between 3 closely spaced lines in excel graph
How do i change the excel chart features such that the 3 series /lines i have
are spaced further apart when displayed in a line graph. I think it must be something to do with scales but tried variations to no effect. Thanks Mike |
|
#2
|
|||
|
|||
|
Hi,
Changing the y axis Minimum and maximum scale values may help. But not if the actual values are very similar and span a large range. Double click the y axis and on the scale tab enter alternative min/max values. Cheers Andy CookeMJ wrote: How do i change the excel chart features such that the 3 series /lines i have are spaced further apart when displayed in a line graph. I think it must be something to do with scales but tried variations to no effect. Thanks Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Thanks Andy - your right actual values are very similar and the range goes
from 0 to 8. I've changed min and max values and not a lot of difference. Thanks for the response regards Mike "Andy Pope" wrote: Hi, Changing the y axis Minimum and maximum scale values may help. But not if the actual values are very similar and span a large range. Double click the y axis and on the scale tab enter alternative min/max values. Cheers Andy CookeMJ wrote: How do i change the excel chart features such that the 3 series /lines i have are spaced further apart when displayed in a line graph. I think it must be something to do with scales but tried variations to no effect. Thanks Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
one of the thhings you might do to show the difference is to pick one as a
basis, then show deltas to the other two. You can plot these three curves on the same chart and just plot the basis on a different axis. "CookeMJ" wrote: Thanks Andy - your right actual values are very similar and the range goes from 0 to 8. I've changed min and max values and not a lot of difference. Thanks for the response regards Mike "Andy Pope" wrote: Hi, Changing the y axis Minimum and maximum scale values may help. But not if the actual values are very similar and span a large range. Double click the y axis and on the scale tab enter alternative min/max values. Cheers Andy CookeMJ wrote: How do i change the excel chart features such that the 3 series /lines i have are spaced further apart when displayed in a line graph. I think it must be something to do with scales but tried variations to no effect. Thanks Mike -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
| Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) | |||
| Pie chart with 'anchored' lines to text box | Charts and Charting in Excel | |||
| Add more lines and more columns in Excel | Excel Worksheet Functions | |||
| How to force continuous lines in line charts | Charts and Charting in Excel | |||
Linear Mode
