Is there a way to Group similar items on the X axis?

********I'm a super idiot -- I cannot figure out how to keep my formatting in this post, so sorry for this being smooshed************

I have data that looks like this:
DISTRICTS TESTS PERCENT IN HFZ
Alphaeus District Editing BMI 100
Alphaeus District Editing CurlUp 100
Alphaeus District Editing ModdedPullUp 100
Alphaeus District Editing OneMileRun 100
Alphaeus District Editing OneMileWalk 100
Alphaeus District Editing SitAndReach 100
New DISTRICT BMI 56
New DISTRICT CurlUp 80
New DISTRICT FlexArmHang 100
New DISTRICT ModdedPullUp 56
New DISTRICT OneMileRun 100
New DISTRICT OneMileWalk 20
New DISTRICT Pacer15 50
New DISTRICT Pacer20 100
New DISTRICT PBF 80


When I try and chart it I get the whole DISTRICT label going upwards and theTESTS going sideways... causing a jumbled mess....

Is there anyway I can group these Items first so I would get something like this in my chart:

New District
test 1 bar
test 2 bar
test 3 bar
Alph District
test 1 bar
test 2 bar.......etc

This seems like a simple problem that others must have but I cannot find the 'simple' solution... help?

Sounds like you want to look into Pivot Tables. Here's how it looks using pivot tables and pivot chart. Is this what you want?

are you for hire? lol... ya, that is exactly how I need to do it (although I need horizontal bars)..... I was hoping there was a way without having to learn about pivot tables....

Mainly because I am trying to call this chart data in an ASP.Net program that I am writing and fear learning the VBA stuff to stick in my program... What I have been doing so far is recording a Macro - making the chart - going to Edit the macro and then snatching the VBA code to put into my program (with some minor changes).

I am not even sure if I can create a Pivot Table from code.... ? But this is my start so thanks a billion!!!!
t

Are you for hire?

Only if you need a chemist.
Try playing around with pivot tables. I was afraid of them too but they are not that complicated and can be very helpful.

As to whether you can create pivot tables with code; I'd say yes but I am only a novice with VBA. Good luck.

hk,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the words No prefix.
Change to Solved
Click Save