Projecting points to stand out in an Excel Graph 1

[appnair]

The concept that I am trying to do is fairly simple.It invoves an x axis with time periods spaced weeks apart.My first Y axis is growth which is linear.However at certain steps or points on the Growth I have a calculation.For eg when the growth crosses 1 GB then I have to indicate or make it stand out. so that when a user sees my graph it becomes obvious that 1 GB more memory is needed.Is that possible with excel.Too Bad I can't put my spread sheet here but I will include the sample data as a google document in case some person has some ideas to help me out.BTW I see that Google docs won't support my charts.In any case here's the data.

http://spreadsheets.google.com/pub?key=rVOOpcvDykOVs5oTgXYNRtQ&gid=0

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer and probably certfiable,Livelink ECM Champion 2008

http://www.linkedin.com/in/appunair

 

[SkipVought]

Hi,

Why not plot a 1GB threshhold across the chart in another series?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[appnair]

well that sounds alien to me.Is the 1 Gb threshold something that I can figure out by doing a google term.I am really not that familar with excel hence the qns.If the 1 GB threshold is charted as you say will it stand out when it hits 2 Gb etc that is exctly what I think am trying to do.I will keep checking

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer and probably certfiable,Livelink ECM Champion 2008

http://www.linkedin.com/in/appunair

 

[SkipVought]

This is not a VBA problem.. It's an Excel chart issue. IMHO, you do not need any code.

So you want to know when a series crosses the 1GB, 2GB or 3GB boundary>

1. you could set the y-axis Scale Major Unit to 1GB.

or

2. you could plot 3 separate series for 1GB, 2GB & 3GB.

Pick your poison.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}