Thanks for responding. It looks like the link that you provided is regarding
different types of scales (percentages and amounts). I have one type of
scale (amounts). The problem I have is that some categories have numbers in
the hundreds and other categories have amounts in the thousands. When I
create the chart, the increments are in the thousands, which will not show
the trends of the smaller amounts. Is there a way to have some type of
incremental separation or "break" on the Y axis?
"Luke M" wrote:
You mean like this?
http://peltiertech.com/Excel/ChartsH...venScales.html
--
Best Regards,
Luke M
"Two sets of intervals on Y axis" Two sets of intervals on Y
wrote in message
...
Hi,
On an XY scatter chart, how can I have two sets of intervals for the Y
axis
without doing a secondary scale? My data varies greatly and does not show
the trend for some of the categories.
Thanks.
.