Bar Graph not allowing choice of X axis

T

tshad

I am trying to get my Bar graph to put the money in my table on the Y-axis,
but it puts it on the X-axis. My table is:

Response Amount
1 $200,000
2 $162,000
1 $75,000

but even if I switch it and put the amount first, it still puts the dollars
on the X-axis.

How do I tell it to put the amount on the Y-axis?

Thanks,

Tom
 
J

John Mansfield

Assuming an embedded chart, click on it once to activate it.

Go to Chart -> Source Data -> Series

In the Series dialog box, remove the series reference for the dollars. Then
add that same reference into the Category (X) Axis Labels input.
 

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

Top