Forum Discussion
Chart Data Range grows as I insert new rows at the top
I have a table and two graphs overlaid. I want the chart data range to remain fixed from row D2-D40. I am using this range, that I got from somewhere on the Internet, which I don't understand it ver...
wcstarks The 'Q 1!' bit merely refers to the sheet name of the range referenced after it. If you are referencing cells in the same sheet where the formula is entered, you can just delete it.
But perhaps you can upload an example of your workbook (replace any confidential information though) so that someone out here can have a closer look. It seems you want the graph to only include the first 40 rows of data in your table. Correct?