Anomandaris
06-03-2009, 08:44 AM
Hello again folks,
I'm trying to write a macro to make a line graph out of a set of data
Workbook contains 2 sheets - "DV-IVSpread" with data, it has 3 tables, Table 1 contains data that is represented in the grid on the other sheet "HeatMap", and Table 3 contains the data that I need to display in a line graph (but it will be 1 column at a time, e.g. graph of '1mx1y', graph of '3mx1y', etc....)
I will get back to this in a moment.
Now lets look at sheet"Heatmap", see the grid,
'1mx1y' on Table 1 in "DV-IVSpread" is shown in the grid, with '1m' on the Y axis(vertical) and '1y' on the X-Axis(horizontal).
So what I want is to click on the 1st square of the grid(cells C5:C7), and when I do that it makes a line graph for the data pertaining to 1mx1y on Table 3 (which has data for around 2 yrs). And I want that for all the 64 squares in the grid.
This means I need 2 things:
1. A code to make the line graph. There will only be one line graph displayed at a time (a small one abt half the size of grid), only a graph of the gridsquare that i select.
2. I need to be able to click on these grid squares...how do I do that, text boxes are not working..I need something like a transparent square box on top of each gridsquare so that I can still see the numbers and the colour, but at the same time be able to clic kon it to initiate the macro.
hope i was clear there
please advise, thanks
I'm trying to write a macro to make a line graph out of a set of data
Workbook contains 2 sheets - "DV-IVSpread" with data, it has 3 tables, Table 1 contains data that is represented in the grid on the other sheet "HeatMap", and Table 3 contains the data that I need to display in a line graph (but it will be 1 column at a time, e.g. graph of '1mx1y', graph of '3mx1y', etc....)
I will get back to this in a moment.
Now lets look at sheet"Heatmap", see the grid,
'1mx1y' on Table 1 in "DV-IVSpread" is shown in the grid, with '1m' on the Y axis(vertical) and '1y' on the X-Axis(horizontal).
So what I want is to click on the 1st square of the grid(cells C5:C7), and when I do that it makes a line graph for the data pertaining to 1mx1y on Table 3 (which has data for around 2 yrs). And I want that for all the 64 squares in the grid.
This means I need 2 things:
1. A code to make the line graph. There will only be one line graph displayed at a time (a small one abt half the size of grid), only a graph of the gridsquare that i select.
2. I need to be able to click on these grid squares...how do I do that, text boxes are not working..I need something like a transparent square box on top of each gridsquare so that I can still see the numbers and the colour, but at the same time be able to clic kon it to initiate the macro.
hope i was clear there
please advise, thanks