recomendation abt this graph.. compare 3 years $$

[mario rdz]

Hello all.
Im trying to show in this graph how much the company puchase by certains purchase order types. The graph needs to shows history from the last 3 years. I have added some basic VB code to manipulate the selecion of business sectors and to show/not show values for the years

But I'm not sure if the graph is the best way to show the history for the 3 years ??

Any advice or sugestion will be very appreciated.

Regards
Mario

 

[Hui]

Instead of an Area, Column and Line charts to show different years I would just use 3 line charts with different formatting

I use different chart types top show different measures, but in your case the measures are all the same

 

[mario rdz]

Thanks Hui, I thing I'm going to re-design whole thing...

regards