changing scales

[Bryan]

How do I change the range of one item in a chart that has several items?
The X axis is time and the Y axis has several items. I want to change the
range of just one of the Y axis items.

Thanks for your time,
Bryan

 

[ChasGo]

Attach the "item" ("series") to a secondary Y-axis. To do
this: Click once on that series and choose Format>Series |
Axis. Then choose "secondary." Format the new axis with
any scaling you prefer, keep it visible (on the right), or
format it for no labels or tickmarks if you want it IN-
visible.

HtH

 

[Bryan Kelly]

Well, that was not at all intuitive, but you got me there.

When I select to create a chart as a separate sheet, I can no longer change
its size. When it is an object, I can select the chart, then pick the dot
on the right vertical edge of the chart and stretch it out as far as I want
to view details. How can I "zoom in" when the chart is in a separate sheet?
I don't want to zoom in vertically, just horizontally.

Thank you for your time,
Bryan

 

[Jon Peltier]

Bryan -

Do you want to change the axis scale to focus only on a portion of the
range? Double click on the axis, click on the Scale tab, and change the
min and max settings. This works on all Y axes, but only on X axes in
scatter charts (not on the category axes of line charts).

- Jon

 

[Bryan Kelly]

I have some data to chart where the first column in time, and several
columns to the right are data to plot. One column may be pointing angle
with a range of 0 to 360 while the next may be angular velocity with a
range of 0 to 10 or less. Instead of having the velocity crammed down into
the -10 to +20 range of 0 to 360, I want it to have its own range of 0 to 10
extending from the top to the bottom.

 

[Jon Peltier]

Bryan -

Before you were talking about stretching horizontally, but now it's
vertically. You can have two built in scales using Excel's standard
features, provided you have at least two chart series. Double click on
one of the series, and on the Axis tab, select Secondary. This gives you
a secondary Y axis to go with the primary X and Y axes. To get the
secondary X axis to show up, right click on the chart, choose Chart
Options, click on the Axes tab, and check the Secondary X box.

Excel doesn't have the built in funtionality to get more than two axes,
but you can fake a tertiary axis (and more, if you don't mind cluttering
up the chart) using a technique on my web site:

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

- Jon