How to add an average line to a bar chart?

[Dmitry]

Hello specialists!
How to add an average line to a bar chart like in the following chart?:

Best regards,
Dima

[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

[Dmitry]

Thanks Andy Pope!
"Andy Pope" <[email protected]> сообщил/сообщила в новостях следующее:
news:[email protected]...
> 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

[Dmitry]

Which method is better?
"Andy Pope" <[email protected]> сообщил/сообщила в новостях следующее:
news:[email protected]...
> 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]

<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" <[email protected]> сообщил/сообщила в новостях следующее:
> news:[email protected]...
>
>>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

[Dmitry]

Thanks Andy!
"Andy Pope" <[email protected]> ???????/???????? ? ???????? ?????????:
news:[email protected]...
> <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" <[email protected]> сообщил/сообщила в новостях следующее:
> > news:[email protected]...
> >
> >>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