Re: How to overlay(?) additional data on a series

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

koday@xxxxxxxxxxxxxxxxx



"DavidJ726" <DavidJ726@xxxxxxxxxxxxxxxx> wrote in message
news:%23WQjnLHaGHA.4548@xxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: How do I change the order of the line versus the marker for a
    ... "Send to back" commands work on the markers and lines? ... back and make changes to a chart. ... Does everything plotted on the secondary axis appear in ... of objects plotted on the primary axis? ...
    (microsoft.public.excel.charting)
  • Re: Create Chart with 2 value axis in PowerPoint 2003
    ... When I set up the chart, I changed the first 0 to 100 in dummy data A. This was just so I could select the series easily and see the bar on the chart. ... After you set each data series to the correct axis, change the 100s back to 0 so no data shows in the dummies and looks like it does above. ... West (on the secondary axis) overlaps DDB in the second position. ... Fixing PowerPoint Annoyances http://tinyurl.com/36grcd ...
    (microsoft.public.powerpoint)
  • Re: Create Chart with 2 value axis in PowerPoint 2003
    ... That did it Echo! ... When I set up the chart, I changed the first 0 to 100 in dummy data A. This ... After you set each data series to the correct axis, ... the secondary axis) overlaps East in the first ...
    (microsoft.public.powerpoint)
  • Re: xy-scatter-labels disappear when x-axis is changed into time-axis (XL07)
    ... I can put the scatter on secondary text-axis. ... But if I make secondary axis invisible, it inherits the behavior of primary ... Then I have to translate the x-coordinates from dynamic axis to a fixed one. ... Using a time-axis, in <=2003 it was also possible to place a scatter ...
    (microsoft.public.excel.charting)
  • coils and hydrogen
    ... A simple coil which is part of a tuned circuit can contain a plasma (there ... is no force along the axis so it won't get sqeezed out) and once the plasma ... The mean free path of an ion depends on the pressure at low pressures this ... In an electric field an ion pickes up energy from the field and the longer ...
    (sci.energy.hydrogen)