| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining scale on y axis
Hi there,
I have a simple, single line chart. The X axis has 4 values which are the same as the data points i.e. 0, 9, 14, 21 The Y axis data is 0,13,17,25 The Y axis defaults to 0 - 30 in intervals of 5. Is there some way to force the Y axis to show lines and intervals like the data, i.e. at 0,13,17,25? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Defining scale on y axis
Hi Sarah,
One way is to use some dummy series to create the lines yourself. After you have created the lines you can turn off both the Yaxis values and the Yaxis gridlines. Click on this link to find out more. http://peltiertech.com/Excel/Charts/...s.html#AddLine HTH Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Linear Mode
