David

Why don't you send me your file and I'll see what I can do.



...Kelly


"DavidJ726" wrote in message
...
Hi Kelly,

You and Andy (whom I just responded to) are both saying the same thing. I
guess I need to go back and try again. But when I plotted the series
using the secondary axis, and tried various ranges, the data was either at
the bottom of the chart, or when using a smaller scale, the data was
accurate just not displayed in a meaningful location. What I really need
is for the pressure reading to be displayed on the line at the
corresponding time and temp using the primary axis. Does that make sense?
( I wish we could post snapshots he-))

Thanks,
David...

"Kelly O'Day" wrote in message
...
David:

As I understand your problem, you want to plot temp (150 - 475) and
pressure (1 - 12) against time. The pressure readings are showing up very
small because the temperature range is much higher.

You can solve this by using a secondary axis for the pressure readings.
To create the secondary axis for pressure readings, select the pressure
series by right clicking it, Click the Selected Object Select Axis
Secondary Axis Option Button.

You can format the secondary axis by adding title and setting range to
fit your needs.

..Kelly





"DavidJ726" wrote in message
...
I'm using a line chart that has 5 columns and 100's of rows to display
time and temperature for a coffee roaster. Time & temp data is measured
by digital probes (etc.), which is imported into a spreadsheet. There's
a temperature reading for every second so I can end up with up to a 1000
rows of data for a 16-17 minute roast.

The Y axis is Temperature. The minimum value is 150 degrees with a
maximum of 475 and has a 25 degree scale.

Column A is where I enter a value of 00:00, 00:30, 1:00, 1:30, etc... up
to 17 and this is used for the X axis labels. Column B (Series A) is
where I'll enter a dozen or more temperatures along the time line and is
used to display a desired profile. Columns C & D is the imported data
showing bean (Series B) and ambient (Series C) temperatures in the drum.

During the roast, temperatures are monitored and gas pressure is
regulated to increase or decrease the heat. The reading on the pressure
gauge is what I need to show along the Series B line so I can observe
the effects of the gas adjustments to the roast. The values I'm
recording range anywhere from 1 - 12 and are entered into column E at
whatever point in time the adjustment was made.

I can't plot it as a series because the values are to small for the Y
axis, and text boxes would be to labor intensive. Is this possible?

Thanks,
David