| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2007 won't display numbers on the vertical axis of column ch
I've been struggling for a while with this one and can't seem to find a
solution. I want to plot some series in a column chart, with values ranging from 3E-18 to 8E-18. However, after plotting the chart, the vertical axis does not display the numbers; only 0 at the bottom with empty space up the rest of the left hand side. Is it because the numbers are so small? Nothing I change in format axis seems to alleviate this problem and I have plotted the same graph in Excel 2003 previously without a problem. Does anyone know what I'm doing wrong? Thanks in advance |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Excel 2007 won't display numbers on the vertical axis of columnch
Hi,
Looks like a bug. Scale is okay with 3E-15 values. You can use this work around to create your own axis scale. http://peltiertech.com/Excel/Charts/ArbitraryAxis.html Cheers Andy andytribo wrote: I've been struggling for a while with this one and can't seem to find a solution. I want to plot some series in a column chart, with values ranging from 3E-18 to 8E-18. However, after plotting the chart, the vertical axis does not display the numbers; only 0 at the bottom with empty space up the rest of the left hand side. Is it because the numbers are so small? Nothing I change in format axis seems to alleviate this problem and I have plotted the same graph in Excel 2003 previously without a problem. Does anyone know what I'm doing wrong? Thanks in advance -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Chart with multiple vertical axis | Charts and Charting in Excel | |||
| Excel 2007 Surface Plot with Logarithmic vertical axis crash | Charts and Charting in Excel | |||
| Graph - display Category (X) axis in the vertical position | Excel Discussion (Misc queries) | |||
| Excel 2007 - Switch vertical and horizontal axis? | Excel Discussion (Misc queries) | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Linear Mode
