Hi,
I was wondering if someone could help me with this. I tried looking for a solution to this, but haven't been able to find one.
I have a chart that references a range of data. Let's assume A1:A5. I need to insert a row at the top with a new set of values periodically. BUT, I want the chart to continue referencing A1:A5, not A2:A6 (which happens when I insert a row). Is there a way of creating an absolute reference?
I found workarounds by creating a macro that readjusts the range, but is there a simpler and better way of doing this? I know that for cells you can use the INDIRECT function. I tried that in the source data, but it results in an error. Can anyone help me? Thanks!
I was wondering if someone could help me with this. I tried looking for a solution to this, but haven't been able to find one.
I have a chart that references a range of data. Let's assume A1:A5. I need to insert a row at the top with a new set of values periodically. BUT, I want the chart to continue referencing A1:A5, not A2:A6 (which happens when I insert a row). Is there a way of creating an absolute reference?
I found workarounds by creating a macro that readjusts the range, but is there a simpler and better way of doing this? I know that for cells you can use the INDIRECT function. I tried that in the source data, but it results in an error. Can anyone help me? Thanks!