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?

Can I abbreviate one value in a data series?
 

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

Can I abbreviate one value in a data series?
 

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