Computer Hope

Other => Other => Topic started by: Sash76 on April 24, 2018, 11:31:43 AM

Title: Excel Graph - comparison
Post by: Sash76 on April 24, 2018, 11:31:43 AM

HI All,
My name is Sascha and I'm struggling to put a sales graph together. Sorry if something similar was posted already. If yes please direct me...

What I want to do is compare last years turnover, target (budget) and current turnover. It will be monthly based but ideally I can print a chart out every week for visualization.  .

Ideally it is a line chart (or something more visual), your suggestions are most welcome. Lets say 2017 is the middle line, target will be above and current turnover will hopefully cut through based on the number.

Sorry I believe it's really simple if you know what you do but I can't figure out. Any assistance oor pointing me in the right direction is greatly appreciated.
Many thanks in advance. 

Title: Re: Excel Graph - comparison
Post by: DaveLembke on April 24, 2018, 06:51:47 PM

Lots of how to's online already covering this stuff. Not sure what version your using so going to assume maybe excel 2013.

https://www.gcflearnfree.org/excel2013/charts/1/

Title: Re: Excel Graph - comparison
Post by: Sash76 on April 25, 2018, 02:02:00 AM

Thank you very much for the links. I will browse through them and surely find a solution.