D
Drew
I was wondering if there is a way to create a break in the
scale of an axis. For example, if column A = 100; column
B = 150; column C = 125; and column D = 10,000. How can I
display a chart that will have the y-axis' scale go from 0
to 200 in small increments and then have a squiggle
(meaning not to scale) and then have the axis end with
10,000. In doing so, one can see the fluctuation between
columns A thru C while still realizing the magnitude of
column D. Currently, column D, due to the abnormally
large number, distorts the chart and one can't see the
fluctuation between A and C (unless the chart is enormous).
scale of an axis. For example, if column A = 100; column
B = 150; column C = 125; and column D = 10,000. How can I
display a chart that will have the y-axis' scale go from 0
to 200 in small increments and then have a squiggle
(meaning not to scale) and then have the axis end with
10,000. In doing so, one can see the fluctuation between
columns A thru C while still realizing the magnitude of
column D. Currently, column D, due to the abnormally
large number, distorts the chart and one can't see the
fluctuation between A and C (unless the chart is enormous).