angelikv
02-15-2007, 07:31 PM
5024
Hi Guys!!!!!
I am working on a homework but I don't know how to make a flexible range on a graph.
This is what I have so far,
Looking at the first sheet, at the second graph, which is time against price. the data table for that graph is the second data table to the side of the graphs. As you can see I know how to make a basic XY scatter chart with this data, but I need to make it so that the user can input a different time period in Cells B6/C6 and that can be reflected in the graph. Basically, how do I make the X-range of a graph flexible?
Thank you!!!! :hi:
Angelica
Ps. See attachment
Hi Guys!!!!!
I am working on a homework but I don't know how to make a flexible range on a graph.
This is what I have so far,
Looking at the first sheet, at the second graph, which is time against price. the data table for that graph is the second data table to the side of the graphs. As you can see I know how to make a basic XY scatter chart with this data, but I need to make it so that the user can input a different time period in Cells B6/C6 and that can be reflected in the graph. Basically, how do I make the X-range of a graph flexible?
Thank you!!!! :hi:
Angelica
Ps. See attachment