How to add an average line to a bar chart?
Hello specialists!
How to add an average line to a bar chart like in the following chart?: Best regards, Dima |
How to add an average line to a bar chart?
Hi,
The following pages have examples of how to add lines. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Dmitry wrote: Hello specialists! How to add an average line to a bar chart like in the following chart?: Best regards, Dima -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
How to add an average line to a bar chart?
Thanks Andy Pope!
"Andy Pope" сообщил/сообщила в новостях следующее: ... Hi, The following pages have examples of how to add lines. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Dmitry wrote: Hello specialists! How to add an average line to a bar chart like in the following chart?: Best regards, Dima -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
How to add an average line to a bar chart?
Which method is better?
"Andy Pope" сообщил/сообщила в новостях следующее: ... Hi, The following pages have examples of how to add lines. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Dmitry wrote: Hello specialists! How to add an average line to a bar chart like in the following chart?: Best regards, Dima -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
How to add an average line to a bar chart?
<tongue firmly in check
Mine of course! </tongue firmly in check It really depends on the complexity of your chart and data. But for a Bar chart the xy-scatter approach would probably be best. Cheers Andy Dmitry wrote: Which method is better? "Andy Pope" сообщил/сообщила в новостях следующее: ... Hi, The following pages have examples of how to add lines. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Dmitry wrote: Hello specialists! How to add an average line to a bar chart like in the following chart?: Best regards, Dima -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
How to add an average line to a bar chart?
Thanks Andy!
"Andy Pope" ???????/???????? ? ???????? ?????????: ... <tongue firmly in check Mine of course! </tongue firmly in check It really depends on the complexity of your chart and data. But for a Bar chart the xy-scatter approach would probably be best. Cheers Andy Dmitry wrote: Which method is better? "Andy Pope" сообщил/сообщила в новостях следующее: ... Hi, The following pages have examples of how to add lines. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm http://www.processtrends.com/pg_char...ontal_line.htm Cheers Andy Dmitry wrote: Hello specialists! How to add an average line to a bar chart like in the following chart?: Best regards, Dima -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com