Help with graphs/excel please. Is VoG there!!

  [email protected]® 18:51 04 Aug 2005

I have some figures that I want to put in a chart which is sales related. I have 5 staff which I have set targets for every day and I want to monitor their progress in a graph.

For example £3000 per day - Actual £2545 etc

Calls 250 per day - Actual 210 etc

Units 6 per day - Actual 4 etc

Returns 20% per day - Actual 23.25% etc

How would I go about this please any easy links or step-by-step ideas. Thanks.

  VoG II 19:11 04 Aug 2005

What exactly do you need help with?

You will need 4 charts because the Y scales are so different.

The easiest thing would be to produce bar charts.

  [email protected]® 19:16 04 Aug 2005

Ok bar charts is ok I know what I want but don't know how to go about it!!

  VoG II 19:23 04 Aug 2005

Basically you select the data that you want to plot, click the ChartWizard button and follow the prompts.

  VoG II 19:49 04 Aug 2005

I meant a Column Chart (oops!).

Have a look click here and click here

  [email protected]® 19:56 04 Aug 2005

I just think it is too difficult. Maybe if you don't mind VoG I will send the spreadsheet for you to look at tomorrow evening.

  VoG II 19:58 04 Aug 2005

OK, I've sent you a PM. Please reply with the spreadsheet attached.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?