?
Solved

BAR CHART in EXCEL data is upside down..

Posted on 2005-04-11
7
Medium Priority
?
1,281 Views
Last Modified: 2008-03-10
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
0
Comment
Question by:Shaft960
  • 4
  • 3
7 Comments
 
LVL 81

Expert Comment

by:byundt
ID: 13756802
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
 
LVL 81

Expert Comment

by:byundt
ID: 13756830
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
 

Author Comment

by:Shaft960
ID: 13757146
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Shaft960
ID: 13757267
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
 
LVL 81

Accepted Solution

by:
byundt earned 1000 total points
ID: 13757328
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
 
LVL 81

Expert Comment

by:byundt
ID: 13757350
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
 

Author Comment

by:Shaft960
ID: 13757753
Excellent Brad.  Thank you again.

Look at my shortcut question when you have a chance.

Thanks

Steven
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

755 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question