| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
On a secondary Y-axis, scale values are repeated: 1, 1, 2, 2.
I moved a data set to its own secondary axis. It was graphing correctly when
combined on the left Y-axis, but when I split it out, the new, righthand Y-axis had duplicate scale values: 1, 1, 2, 2, with the max set at 1.5. The general shape of the data is correct, but you can't read any value with the duplicated scale entries! How can I fix this?? Bill Bornak |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
On a secondary Y-axis, scale values are repeated: 1, 1, 2, 2.
Hi,
Check the number format for the scale it may be set to 0 instead of General. Double click axis and on format dialog pick Number tab. Cheers Andy Bill Bornak wrote: I moved a data set to its own secondary axis. It was graphing correctly when combined on the left Y-axis, but when I split it out, the new, righthand Y-axis had duplicate scale values: 1, 1, 2, 2, with the max set at 1.5. The general shape of the data is correct, but you can't read any value with the duplicated scale entries! How can I fix this?? Bill Bornak |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching the min & max values for Primary and Secondary axes | Charts and Charting in Excel | |||
| Y Axis is repeating values - can't figure out why | Excel Discussion (Misc queries) | |||
| Secondary Axis | Charts and Charting in Excel | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| Secondary Axis? | Charts and Charting in Excel | |||
Linear Mode
