Hi,
New to the forum and whilst not new to Excel, I'm not exactly proficient at it, please go gentle on me...
So, my problem.
Basically, I have a chart. This chart's horizontal axis will remain constant, however, I want to be able to change the series value data range based on the value of 2 cells.
So, at the moment, I have 2 cells, in this case K1 + K2. Both cells contain an IF statement that will spit out another cell reference (say H2 + H39) based on the condition met in the if statement.
So I want to be able to take the value of these 2 cells and use them as the data range for the series data, so that when the condition in the IF statement changes, the series data will display a different range of data on the chart.
And I'm stumped, I have no idea how to do it. I've got as far as trying - $K$1:$K$2, realising that clearly doesn't work and have tried scouring the internet for help with no such luck. So any help would be very appreciated :D
Bookmarks