CHARTS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gerard L - 27 Sep 2007 19:54 GMT

If you have one column in a chart that is so tall it distorts the rest of the
columns, i.e. they are so small you cannot distinguish the reading, is there
a way of creating a split in the one column and the axis?

Reply to this Message

Ron Coderre - 27 Sep 2007 20:36 GMT

See how Jon Peltier handles that situation:
http://www.peltiertech.com/Excel/Charts/axes.html#Broken

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

> If you have one column in a chart that is so tall it distorts the rest of
> the
> columns, i.e. they are so small you cannot distinguish the reading, is
> there
> a way of creating a split in the one column and the axis?

Reply to this Message

gerard L - 28 Sep 2007 07:18 GMT

Ron - many thanks. From looking at the link it is EXACTLY what I am trying to
do. I will follow through the procedure today to see if I am able to
implement (through my basic excel knowledge - not your info!)

Regards

Gerard L

> See how Jon Peltier handles that situation:
> http://www.peltiertech.com/Excel/Charts/axes.html#Broken
[quoted text clipped - 12 lines]
> > there
> > a way of creating a split in the one column and the axis?

Reply to this Message

Ron Coderre - 28 Sep 2007 12:26 GMT

Thanks for the feedback....Jon's website is a great resource.

***********
Regards,
Ron

XL2003, WinXP

> Ron - many thanks. From looking at the link it is EXACTLY what I am trying to
> do. I will follow through the procedure today to see if I am able to
[quoted text clipped - 20 lines]
> > > there
> > > a way of creating a split in the one column and the axis?

Reply to this Message