Excel help please

[The Pink Panther]

Fellow posters, I have to complete a sales report and need to create a bar chart

It will be for 2016 and 2017 and ideally what I'm after is the bar chart for two years (different colours) with sales on the left and months along the bottom and also a separate column for monthly financial figures which have a rolling total (hope that makes sense)

I've been searching around Excel on the laptop but can't find anything suitable

Can anyone help?

 

[LWashington]

https://www.smartdraw.com/downloads/download.htm

7 days free trial.

 

[Danamy]

Google is your friend, loads of guides on YouTube:

 

[The Pink Panther]

thanks

 

[TheRemainsOfTheDave]

Fellow posters, I have to complete a sales report and need to create a bar chart

It will be for 2016 and 2017 and ideally what I'm after is the bar chart for two years (different colours) with sales on the left and months along the bottom and also a separate column for monthly financial figures which have a rolling total (hope that makes sense)

I've been searching around Excel on the laptop but can't find anything suitable

Can anyone help?

Did you get it sorted?

Should be a straightforward bar chart with two bars for every month (one for the actual figure and one for the accumulating amount).

Or, a combination chart with one bar per month (actual) and a line for the accumulative figure.