Employees Needed In An Office

[Guest]

I need to take the number of customers we have in one day -vs- the number of sales written and use this to make a chart
to show how many employee are needed in the office.

 

[AlfD]

Hi!

More information?

If you only use no. of customers and no. of sales written it won't sa
much about staff levels. What data are you using besides these two?

Making a chart using these two is not difficult - but not particularl
relevant to your enquiry, I think.

Put the No. of customers and No. of sales in contiguous columns.
Highlight the data.
Use the Chart button on the menu ( or use Insert > Charts) and choos
XY scattergraph. There are versions with or without lines joining u
the points.

Al

 

[Debra Dalgleish]

Jon Peltier has a charting tutorial that should help you set up the data
on the worksheet, and create the chart:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html