Excel Chart Break 1

[gentrya]

I'm working on an Excel 2000 column chart that has data from 0-10 and 70-100 on the same chart. Is there some way to cause a "wave" or break in the value axis as well as the column so that the data on the lower values does not "disappear"?

Thanks!
age

 

[SkipVought]

gentrya,

You can see what you are referring to.

We cannot.

Please "paint a picture" that will "make it perfectly clear", to quote a fallen politician, what you see and what you want.

Please be CLEAR, CONCISE and COMPLETE.

Skip,

_[red][/red]

 

[gentrya]

Here is an example of the data.

2003 2004 2005 2006
Jan 120 101 115 109
Feb 0 9 10 4
Mar 76 65 80 83

I have the column chart that has the full scale on the value axis. I would like to have all the data charted on the same graph only the axis would go from 0-15 and re-start at 60+. The "break" would noted on the axis and the columns.

I hope this clarifies. Sorry. Thank you!

 

[SkipVought]

You can simulate a chart with a broken axis and broken columns by stacking TWO SEPARATE CHARTS (copy 'n' paste your chart to get TWO).

Change the MAX scale on the lower chart and the MIN scale on the upper chart.

It will take some tweeking.

Skip,

_[red][/red]