Change chart axis

[el_ja]

Hello guys I have a question that I think I saw in school but right now I don't remember ^^
I have this set of data:
<table width="379" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="width:60pt" width="80" span="4"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl63" style="height:12.75pt;width:44pt" width="59" height="17">Concept</td> <td class="xl66" style="width:60pt" width="80">1-May-11</td> <td class="xl66" style="width:60pt" width="80">1-Jun-11</td> <td class="xl66" style="width:60pt" width="80">1-Jul-11</td> <td class="xl66" style="width:60pt" width="80">1-Aug-11</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">A</td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">200 </td> <td class="xl64" align="right">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">B</td> <td class="xl64" align="right">1 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">C</td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">1 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">D</td> <td class="xl64" align="right">211 </td> <td class="xl64" align="right">100 </td> <td class="xl64" align="right">30 </td> <td class="xl64" align="right">105 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">E</td> <td class="xl64" align="right">2 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> <td class="xl64" align="right">0 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">F</td> <td class="xl64" align="right">45 </td> <td class="xl64" align="right">45 </td> <td class="xl64" align="right">42 </td> <td class="xl64" align="right">44 </td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">G</td> <td class="xl64" align="right">3 </td> <td class="xl64" align="right">3 </td> <td class="xl64" align="right">5 </td> <td class="xl64" align="right">4 </td> </tr> </tbody></table>
And I want to make a chart that shows the dates in the vertical axis and the concept (a,b,c...) in the x axis.
Right now I keep getting this result:



But I want it to be more like this (not at scale at all, but its the idea)

Hopefully somebody can help me thanks a lot

 

[Steve=True]

Hi,

I am not sure you can do what you want to have done.

The reason is how tall is "A" and how tall is "B"?

You can get the letters on the Xaxis, but they need a value for the YAxis.

Here is a sample


Steve=True
www.exceldashboardtemplates.com

 

[el_ja]

Oh well, I'll try to find some other solution to display the data as I wanted.
Thank you very much for your answer