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 |