If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
How to create a chart that compares monthly data with an avera
Thanks Jon, that's PERFECT!
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. |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|