How to create a chart that compares monthly data with an average
 

Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year to
be beside each group of columns so each persons sales are compared to the
average from last year.

How to create a chart that compares monthly data with an average
 

Instead of adding the average as another bar, why not add it as a horizontal
line:

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

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Meenie" wrote in message
...
Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year
to
be beside each group of columns so each persons sales are compared to the
average from last year.

How to create a chart that compares monthly data with an average
 

See
Adding a horizontal line to a chart
http://www.tushar-mehta.com/excel/ch...nes/index.html
or Jon Peltier's http://peltiertech.com/Excel/Charts/AddLine.html

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Meenie" wrote:

Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year to
be beside each group of columns so each persons sales are compared to the
average from last year.

How to create a chart that compares monthly data with an avera
 

Thanks Jon, that's PERFECT! :D
Meenie

"Jon Peltier" wrote:

Instead of adding the average as another bar, why not add it as a horizontal
line:

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

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Meenie" wrote in message
...
Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year
to
be beside each group of columns so each persons sales are compared to the
average from last year.

How to create a chart that compares monthly data with an avera
 

Thanks! I had already used Jon's but can see your's would have worked as well.
Meenie

"Tushar Mehta" wrote:

See
Adding a horizontal line to a chart
http://www.tushar-mehta.com/excel/ch...nes/index.html
or Jon Peltier's http://peltiertech.com/Excel/Charts/AddLine.html

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Meenie" wrote:

Excel 2003:
Jan Feb Mar
Moe 20 24 16
Joe 15 28 24
Flo 25 22 12

Ok lets say the average sales per month for last year was 22.
I want to make a plain clustered column chart that shows what Moe Joe and
Flo each sold for Jan Feb and Mar and want the Average Sale from last year to
be beside each group of columns so each persons sales are compared to the
average from last year.