Plotting a graph to show individual SKU sales over time, revised.

[JumpInTheFire83]

Hi, Please see the image below showing sales for each SKU over each week;

What I am trying to set out to do is almost complete at this stage, but it's not quite right. Ideally I would like to have each date as a point along the bottom, and to have the values on the right Y axis. Therefore there would be only one line coming from each SKU label on the left Y axis, and not like it is currenty.


This may be better done on a line graph, but my main problem is getting the SKU's on the left Y axis, the values on the right Y axis, and the dates going along the bottom X axis.

Is this possible?


Thanks

 

[Steve=True]

Hi JumintheFire83.

To get what you desire, change your chart type to Column Chart
and then press the switch row/column button on the design ribbon.

Here is more about Switch Row/Column

why-does-excel-switch-rowscolumns-in-my-chart

Hope this helps.

Steve=True