Need to use an offset for x-axis in chart/graph
 

I have tried to describe what I wish to do in as much detail as possibl
in my first post. I will try to again summarize my problem:

I have a macro which creates a chart using Row# as the X-value
(x-axis) and a data point in that row for the Y-value. I want t
create an offset on the x-axis to manipulate the value seen on th
chart (see my example in my first post).

Is there a method which can be used in creating a chart (via VB macro
which will allow me to define this offset?


Thanks again

--
melisfree
-----------------------------------------------------------------------
melisfreed's Profile: http://www.excelforum.com/member.php...fo&userid=1614
View this thread: http://www.excelforum.com/showthread.php?threadid=27768

Need to use an offset for x-axis in chart/graph
 

Your first post isn't visible in the newsgroup where most are reading this
(as opposed to Excelforum), so making reference to it isn't of much help.
The first visible post in this thread is something like "I am still looking
for help"

As long as you are setting the graph to graph a specific range, you would
not be able to make the graph subtract a fixed value from each data point.
You would need to have your macro build another row that uses formulas to
produce the revised values and use that as the source for the graph.

--
Regards,
Tom Ogilvy

"melisfreed" wrote in message
...

I have tried to describe what I wish to do in as much detail as possible
in my first post. I will try to again summarize my problem:

I have a macro which creates a chart using Row# as the X-value
(x-axis) and a data point in that row for the Y-value. I want to
create an offset on the x-axis to manipulate the value seen on the
chart (see my example in my first post).

Is there a method which can be used in creating a chart (via VB macro)
which will allow me to define this offset?


Thanks again!


--
melisfreed
------------------------------------------------------------------------
melisfreed's Profile:
http://www.excelforum.com/member.php...o&userid=16140
View this thread: http://www.excelforum.com/showthread...hreadid=277687