What is the best chart for this....

[Patti]

When I want to compare how each salesperson's sales contributes to Total
Sales, I can use a pie chart. But what do I use when I want to compare how
each salesperson performed against the *average* of total sales?

I am envisioning a vertical bar chart with a horizontal line at the average,
but I need a solution that can be generated by a macro.

Any advice? Thanks in advance.

Patti

 

[Jon Peltier]

Patti -

That's how you would do it, a column chart with a horizontal line. On this web page, I give a
couple techniques to achieve the horizontal line:

http://peltiertech.com/Excel/Charts/AddLine.html

You could set up this chart in a workbook, and have your macro simply update the data. The chart
will adjust to the changing data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Patti]

Thanks Jon!

Patti -

That's how you would do it, a column chart with a horizontal line. On this web page, I give a
couple techniques to achieve the horizontal line:

http://peltiertech.com/Excel/Charts/AddLine.html

You could set up this chart in a workbook, and have your macro simply update the data. The chart
will adjust to the changing data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______