Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
data left and right of x axis
tryingt o make a bar chart with values 8,8,3,9,3 i need values under 5 to be
left of vertical axis only and values over 5 to be right... so eight would be 3 places right three would be two places left hope that makes sense.. i have NO idea how to do this HELP!!!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
data left and right of x axis
Right click on the other axis, choose Format...
On the tab that allows you to enter scale parameters, find 'Axis Crosses At' or perhaps 'Category Axis Crosses At' (depending on version) and enter 5 in the box. This will position the crossing axis at 5. The bars will start at this vertical line and move left or right to the values. If you want the bars still to begin at zero, consider adding a line: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "vkada1" wrote in message ... tryingt o make a bar chart with values 8,8,3,9,3 i need values under 5 to be left of vertical axis only and values over 5 to be right... so eight would be 3 places right three would be two places left hope that makes sense.. i have NO idea how to do this HELP!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right axis instead of left axis in chart | Excel Discussion (Misc queries) | |||
Move Y axis values from right to left | Charts and Charting in Excel | |||
how can i move verticall axis to left? | Charts and Charting in Excel | |||
Left Justify category axis | Charts and Charting in Excel | |||
Y Axis Displayed on left and right of graph | Excel Discussion (Misc queries) |