Re: Area Charts With Negative Numbers

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Ritujoy (ritujoyc_at_yahoo.com)
Date: 06/22/04 

Date: 22 Jun 2004 14:36:19 -0700

Thanks to Andy Pope for developing a solution. The correct method is
to shift all the benchmark points to be non-negative and then plot
these new series on a secondary axis. Simple - should have seen it.

Thanks,

Ryan

ritujoyc@yahoo.com (Ritujoy) wrote in message news:<d23bcbda.0406151217.7b88e60b@posting.google.com>...
> I'm curious if anyone has had success trying to design an area chart
> as described below:
>
> 1) The graph depicts annual benchmarks / net returns (Y-AXIS) versus
> year (X-AXIS).
>
> 2) I have three arrays for benchmarks. Array 1 is the bottom quartile,
> array 2 is the median and array 3 is the top quartile. If you picture
> the entire graph, these three arrays break up the chart into four
> regions. Everything below array 1 is the bottom quartile. Everything
> between array 1 and array 2 is the 3rd quartile. Everything between
> array 2 and array 3 is the 2nd quartile and everything above array 3
> is the top quartile.
>
> 3) Currently I'm generating line plots for all the arrays.
>
> 4) I would instead like to have four "areas" on the chart each with
> their own color. Using area charts doesn't seem to work because it's
> looking for absolute value changes.
>
> (5) My crude work around was to set a max, min and scale for two
> charts and then shift one chart to be all positive (add 100% to all
> the array values). Then I put the shifted graph below another graph
> with the real axis (but same scale).
>
> Has anyone thought of a more elegant way or alternatively know how to
> use Excel to accomplish this?

Relevant Pages

  • Re: extract arrays according the number of consecutive values
    ... different plots on a same graph when the value in column A changes.I managed to have 2 arrays (thanks to the forum with some ... modifications):-One to tell me each first indexes when the value changes-One to tell me each last indexes when the values changesMy idea would be to use theses indexes to split the initial ... arrays will be created when I will try to split the initial array.Is someone know if this solution is possible?Thank you in advance for the help. ...
    (comp.lang.labview)
  • problem with gnuplot in XP
    ... I made 2 arrays, which are i and uzuy (both are ... And I want to plot the graph between those ... from Gnuplot import Gnuplot, Data ...
    (comp.lang.python)
  • Re: Plotyy Problems
    ... > I now have a graph that consists of two straight lines, plotted> diagonally across the plot area, however this doesn't seem> representative of my data. ... you just plotted the above arrays which are straight lines -- which is the question I raised earlier of why would you care to plot these against each other???? ...
    (comp.soft-sys.matlab)
  • Re: Image Exporting in Application in Visual c++ 6.0
    ... has 2 arrays of data that I need to plot in my ... application and then export the graph as an image. ... have been able to plot using LineTo function but could please anyone ... tell me how to export this graph in a image file through my ...
    (microsoft.public.vc.language)
  • Plotting Graphs by Arrays
    ... I want to plot scatter graphs for some ... and assigns this to arrays, and the second one plots them. ... Sub AssignValues() ... Dim valueY() As Single ...
    (microsoft.public.excel.programming)