Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase space between values on y coordinate
I have a chart with months along the x axis and temperature readings along
the y axis. Several years are plotte din different colors. There is also a horizontal line representing the annual average for each year. The problem I'm having is that, the annual averages are very similar and therefore one area of teh chart is very busy. I'd like to increase the y value height (ie make the space between each temperature gradient larger). Currently, I have minimum at 1 and major unit at 5. I don't mind if the rest of the chart is enlarged as well. I assumed gap width woudl do this, but the option is greyed out. Thank you. Essentially, I want to increase the gap width for each value on the y axis. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase space between values on y coordinate
Sounds like you need to stretch the whole chart vertically.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Scott" wrote in message ... I have a chart with months along the x axis and temperature readings along the y axis. Several years are plotte din different colors. There is also a horizontal line representing the annual average for each year. The problem I'm having is that, the annual averages are very similar and therefore one area of teh chart is very busy. I'd like to increase the y value height (ie make the space between each temperature gradient larger). Currently, I have minimum at 1 and major unit at 5. I don't mind if the rest of the chart is enlarged as well. I assumed gap width woudl do this, but the option is greyed out. Thank you. Essentially, I want to increase the gap width for each value on the y axis. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make values increase by 1 while going down a cell | Excel Discussion (Misc queries) | |||
Increase values on formattted sheet | Excel Discussion (Misc queries) | |||
Increase a currency grid values by 3% | Excel Discussion (Misc queries) | |||
How do I increase a table values by 1.2 for example? | Excel Worksheet Functions | |||
increase all values in a column by a percentage | Excel Worksheet Functions |