Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Axis Issues
I am having a problem that I think has a simple fix, but I can't figure it out.
I have created a simple bar graph where one bar has a negative dollar value and the rest have positive vales. The problem is that I can't figure out how to leave the x axis at $0.00 value where it intersects the Y axis and have the column labels show at the bottom of the chart. If that makes no sense please see attached picture!! If anyone can help I would be much appreciated!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Axis Issues
Don't change where the category (X) axis crosses the value (Y) axis. Format
the category (X) axis, select the "Low" option for the tick labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "DALLAS6570" wrote in message ... I am having a problem that I think has a simple fix, but I can't figure it out. I have created a simple bar graph where one bar has a negative dollar value and the rest have positive vales. The problem is that I can't figure out how to leave the x axis at $0.00 value where it intersects the Y axis and have the column labels show at the bottom of the chart. If that makes no sense please see attached picture!! If anyone can help I would be much appreciated!! +-------------------------------------------------------------------+ |Filename: cHARTTTTTTT.JPG | |Download: http://www.excelbanter.com/attachment.php?attachmentid=116| +-------------------------------------------------------------------+ -- DALLAS6570 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Display Issues with X-Axis | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |