Showing range in chart
Darius Blaszijk
I've got a question for you about a problem that bugs me frequently.
Lets say I have some data and I want to show the range in which the data is
valid. Normaly I draw a line onto the graph according to the y-axis at that
moment. But when data is added and the axis changes, my line is placed wrong
and I have to position it again. This is a dumb job, because I have to check
every time new data is added. Is there a posibility to add a range band to a
graph that adjusts itself? I have thought about making two columns for each
data column and put the range in it, than add an area serie of the range to
the graph, but somehow I guess this can be done more easy.
Any suggestions??
Many thanks, Darius Blaszijk
EarlK
Depending on where you need the line, you could add a line series, and
provide the appropriate values for the two ends of the line.
You can get fancier and add area series that will appear to change the
background color.
Say more about the chart. What type chart? What kind of data?
--
Regards from Virginia Beach,
EarlK
ea...@livenet.net
-------------------------------------------------------------
"Darius Blaszijk" <DBla...@ZonNet.nl> wrote in message
news:mwKA6.7860$JH6.53935@zonnet-reader-1...
EarlK
You can:
1) Get Harvard Graphics, which has a "goal range" feature that colors in
areas for below, in, and above the goal values. Last I saw, it did not
support linking from other apps, unfortunately.
2) Jump through the following hoops:
Create a series for the bottom of your goal range by adding a bunch of 7.5's
(the low extent of the goal range) in a column and dragging it into the
chart (which will add a series). Select this line and change it to chart
type of stacked area: (do Chart, Chart type, and select Area, stacked
(middle column)).
Create a series for the actual goal range. Yours appears to go from 7.5 to
8.25, so this column would be filled with 0.75. Drag this column into the
chart, set its chart type to area, stacked, and format it for the color you
want. You may want to format both these area series for no border, so you
don't have so many black lines running across the chart. Do this last; set
the color (clear or a color) first. A series with no border and no fill is
damn hard to select, so this is the last exit before tunnel.
Create a line series for the missing gridline (at Y value of 8): Fill a
column with the number 8, drag that in, and format it for the same color as
your other gridlines.
--
Regards from Virginia Beach,
EarlK
ea...@livenet.net
-------------------------------------------------------------
"Darius Blaszijk" <DBla...@ZonNet.nl> wrote in message
news:SK%A6.8328$JH6.56122@zonnet-reader-1...
> Hi Earl,
>
> Yes youre right, I have to be more specific. I'm talking about sample data
> so I use a line graph with the sample date on the x-axis and the analysis
on
> the Y-axis. The samples have to be within a certain range. As you
mentioned
> I used area series to create the range (see added picture below). But my
> problem now is that the background is either opaque (as is now) or fully
> transparent and therefore invisible. Is it possible to show the gridlines
> through the area chart? An other problem was that the area serie need
> exactly the same amount of data as the analysis have. This means two of
the
> three columns contain no significant data. Is there a possibility to
reduce
> this data and let the area serie just look at one datapoint while covering
> the entire width of the graph?
>
>
>
>
>
> Many thanks, Darius Blaszijk
>
> "EarlK" <ea...@livenet.net> wrote in message
> news:OoXi1QiwAHA.1076@tkmsftngp05...