| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Negative values on Y axis
working on a bar chart. Data source contains NO negative values. When
viewing chart in print preview, Y axis shows value of -100. How can I eliminate this? And why is it there in the first place if there are no negative values in the data source? -- DruD |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Negative values on Y axis
Hi,
Check the min value of the Y axis. Double click the Y axis to display the Format dialog. On the Scale tab check whether the Minimum scale is set to Auto or specified value. If Auto then there must be something the chart that is causing this. Are there other data series in the chart, maybe with no formatting. Maybe Error bars or trend line. Cheers Andy DruD wrote: working on a bar chart. Data source contains NO negative values. When viewing chart in print preview, Y axis shows value of -100. How can I eliminate this? And why is it there in the first place if there are no negative values in the data source? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative values in bar chart overlap axis labels. | Charts and Charting in Excel | |||
| Axis labels on negative values | Charts and Charting in Excel | |||
| Move the Y axis below negative values | Charts and Charting in Excel | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Linear Mode
