ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Resizing columns [same data source] (https://www.excelbanter.com/charts-charting-excel/160715-resizing-columns-%5Bsame-data-source%5D.html)

Helene Noel

Resizing columns [same data source]
 
Hi!

I have created a chart where data results from the same source and of the
same kind. But the results of one column are very higher than the others
resulting in a disproportionated first columns which makes the chart
difficult to read for the readers. I often saw charts in publications where
the higher colum is "broken" in the middle, making the chart more
userfriendly.

Can anyone help me on this?

Thanx!

Jon Peltier

Resizing columns [same data source]
 
Here is an illustrated tutorial, with links to a couple others as well:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Helene Noel" <Helene wrote in message
...
Hi!

I have created a chart where data results from the same source and of the
same kind. But the results of one column are very higher than the others
resulting in a disproportionated first columns which makes the chart
difficult to read for the readers. I often saw charts in publications
where
the higher colum is "broken" in the middle, making the chart more
userfriendly.

Can anyone help me on this?

Thanx!




David Biddulph[_2_]

Resizing columns [same data source]
 
Try http://peltiertech.com/Excel/Charts/BrokenYAxis.html ?
--
David Biddulph

"Helene Noel" <Helene wrote in message
...
Hi!

I have created a chart where data results from the same source and of the
same kind. But the results of one column are very higher than the others
resulting in a disproportionated first columns which makes the chart
difficult to read for the readers. I often saw charts in publications
where
the higher colum is "broken" in the middle, making the chart more
userfriendly.

Can anyone help me on this?

Thanx!





All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com