I thought I was nearing 'Intermediate level' but this chart issue has stumped me, so maybe not.
I have a set of data returned by a stored procedure.
Basic format is:
Type Week 1 Week 2 Week 3 ....
Sales 1111 1111 222
Forecast 344 4354 44.5
Stock 3332 22222 2222
All I want to a bar chart, with Week 1, 2, 3 on the x axis, inside each week a bar displaying Sales, one showing forecast I was hoping for a line representing stock, but a bar would do for now. Y axis would be the scale ie 0 to 4500.
I am obviously doing something fundamentally wrong but i feel i've exhausted all the options withing Chart expert, and my resulting graph always has the 'type' column on the x axis, with one bar per week within each type.
Many thanks in advance to anyone who can point me in the right direction.
I have attached images of my 'ChartExpert' options and the graph i keep getting (ie not the one I am looking for)
Start Free Trial