Can we show two column names from a query in X axis barchart

[baba]

Select Year,Type,Count(*) from Table group by Year,Type;
I am running the above query to create a bargraph:

Result of my query:
Year Type Count
---- ----- ------
OCt-10 Type1 5
Apr-11 Type 4 4


Expected graph:

Y axis Counts
X axis Year and then Type together

Two bars in total :
One bar for Oct-2010,Type 1 showing a count of 5
One bar for Apr-2011,Type 4 showing a count of 4
Is it possibe to show Year as well as the Type values as labels in X axis in a barchart. Please let me know.


I know it can be done with pivot charts but I dont know how to create it as a report with pivot barchart .

[June7]

In my experience, X axis can be only one field. You could concatenate the two fields and use that as the X axis. How will that affect plotting your data?

[baba]

Result of my query:
Year Type Count
---- ----- ------
Oct-10 Type1 5
OCt-10 Type 2 7
Apr-11 Type 4 4
Apr-11 Type 5 8
Apr-11 Type 9 1


Oct -10 should have 2 bars .X axis main heading Oct-10 and sub heading should be Type 1 below bar 1 and Type 2 under Bar 2 .
Similarly for Apr-11,there should be 3 bars. Hope I explained my expected results properly. Thanks for the help!

[June7]

Doesn't add any new info and doesn't alter my earlier comment. You could try my suggestion and see if it is adequate.