Can I abbreviate one value in a data series?

I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
the graph?

Hi,

One way is to break the Y axis, have a look at these examples of how to

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://tushar-mehta.com/excel/newsgr...ial/index.html
http://www.andypope.info/charts/brokencolumn.htm

Cheers
Andy

CMEknit wrote:
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other data points show better in
> the graph?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy,

Thank you so much ... this is exactly what I need.

Chris

"Andy Pope" wrote:

> Hi,
>
> One way is to break the Y axis, have a look at these examples of how to
>
> http://peltiertech.com/Excel/Charts/BrokenYAxis.html
> http://tushar-mehta.com/excel/newsgr...ial/index.html
> http://www.andypope.info/charts/brokencolumn.htm
>
> Cheers
> Andy
>
> CMEknit wrote:
> > I've got a chart where one value (8,300) greatly exceeds all the others. Is
> > there a way to abbreviate this value so the other data points show better in
> > the graph?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>