BAR CHART in EXCEL data is upside down..

I have a BAR CHART graph that is working fine.. except the output is backwards... The data is received from an area on the sheet which is hidden..

The source data is

Aquatic Rescues      12
Cliff Rescues      5
Preventative Safety Actions      12
Major Medicals      4
AED Cases       6
C-Spine Injuries       7
Near Drownings       12
Minor First Aids      1

The problem is it is showing the MINOR FIRST AID category at the top and I need it to be the same as the above.. The Aquatic Rescues are on the bottom and I need them on the top just like they were entered.. I have tried to change things but it isn't working..

Thanks..
Steven
Shaft960Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
byundtCommented:
Hi Steven,
1) Right-click the Category axis
2) Choose Format Axis from the pop-up, and go to the Scale tab
3) Check the box for "Categories in Reverse Order"

Cheers!
Brad
0
 
byundtCommented:
Steven,
And if you want the number scale to remain on the bottom, you also need to check the box in the same dialog for "Values (Y-axis) crosses at maximum category"

Brad
0
 
Shaft960Author Commented:
Hi Brad,

I tried that and it did change the order, but not to what I wanted.. I'm sure I gave you wrong info..

The chart shows

Aquatic Rescues                    ******
Cliff Rescues                         ***********
Preventative Safety Actions     ********
Major Medicals                      ****
AED Cases                             **
C-Spine Injuries                     **************
Near Drownings                     *****
Minor First Aids                      **
                                             ------------------------------------------------------
                                             1    4              10    12  ....
The Names like "Aquatic Rescue" are in a legend. In sort of another legend chart.

When I changed it to how you suggested it did reverse the order of the bottom numbers.. It had it start with 12... to 1

I need the bottom numbers in the chart to stay the same and the order of the legend and data in the chart to reverse.. the bottom name of the legend should be at the top.. and the bottom values in the chart need to be at the top as well.

I hope you understand.. Also, I have a question about creating a shortcut through code... if you could check that out that would be cool... I can't get it to work...

Thanks from sunny California..

Steven.


0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Shaft960Author Commented:
I found a way to move the bottom up.. by moving it down.. It says in series order. it has what I want at the top.. but if I move it down to the bottom then it is on the top of the chart.. I guess I could do that to all of them.. but I don't think that is the right way..

0
 
byundtCommented:
Steven,
Please see if either of the bar charts in the sample workbook are what you had in mind: http://home.mchsi.com/~byundt/BarChartReverseOrderQ21384691.xls
Brad
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
byundtCommented:
Steven,
You may have clicked the wrong axis. You want to click the one with the category names--which would be a Y-axis if this were a scatter chart. The numbers that measure the length of the bars shouldn't be changing, just the names of the categories.
Brad
0
 
Shaft960Author Commented:
Excellent Brad.  Thank you again.

Look at my shortcut question when you have a chance.

Thanks

Steven
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.