Home » Forums » Open Source Learning Center » Question and Answer

Automating gray overlay in a graph

Submitted by KasperH on 21 January, 2011 - 20:41

Hey Experts

Sorry about the titel if it doesn't say what i'm looking for, I'll try to explain. I have attached a image of the OMX Copenhagen 20 index over a period of 20 years. In the graph you see some gray overlay. I've are put in manually but I have alot of graph, and I want this to happen automatically.

 

The data is importet via the bloomberg functions in excel and the gay overlay is periods with recessions (def.: two quaters of negative growth in GNP).

 

Is there any with to make excel do this itself, does it include VBA or can it be done without? As you see the x-axis shows the dates and what you cannot see (on the axis but can see on the data) is that it is dayobservations. So I don't think there will be any problems with "finding" dates with this mysterious function that can do the gray overlays.

Graph of OMXC20 index
‹ need to collapse near duplicate rows Random 3D6 Die-Roll and Test ›
»
Nick's picture

graph overlays

Submitted by Nick on 23 January, 2011 - 12:20.

yes

  1. add another series to your data
  2. make the value of the new series equal to the max of the y axis
    • in your example, 600
  3. add the new series
  4. change the graph type to be a line and a column
  5. play around with the formatting of the columns until you have something that looks good

something like this:

 

year Data Grey Area
2000 100  
2001 100.753 105.5
2002 100.8627 105.5

 

»