What is the best chart for this....

  • Thread starter Thread starter Patti
  • Start date Start date
P

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
 
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/
_______
 
Thanks Jon!


Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top