set X-axis cross Y at 0

E

Eric Zhao

Hi,

The Y values of my bar chart are -20, 0, 10, 30. How can I set X-axis cross
Y-axis at 0 point?

Many thanks.
 
W

Wei-Dong XU [MSFT]

Hi,

From my understanding, you are going to draw one chart as below

------|------------------------------
-20 0 10 30

to place the 0 in the middle of -20 and 10. Is my understanding correct?

If so, as I know, this is not supported in OWC. However, I'd suggest you
can change the order, put the x axis as y axis and y axis as x axis. This
should fit your requirement and is supported by OWC.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong XU (WD.XU)
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and filtering text 0
Make Y-axis values correspond to x- axis value 1
Gantt chart duration not showing 0
Secondary axis alignment 0
Secondary axis alignment 0
Use text descriptors as Y axis units 1
Scatter graphs, excel 11 mac user 0
X-axis cross Y at 0 1

Top