Hello,
Im using offset and name ranges to create a dynamic chart. It has both X and Y axis. The idea is to change the information with a drop down menu. So sometimes columns or rows have to be removed automatically. But when i remove a row or columns it gives me an error: excel found a problem with one or more formula references in this worksheet.
Does anyone know how and if this can work?
i cant make it in to a table also because when a value is deleted from the table the chart doesnt update properly (It is left half empty, and i want the information that is left to be properly distributed in the whole chart)
Thank you
Im using offset and name ranges to create a dynamic chart. It has both X and Y axis. The idea is to change the information with a drop down menu. So sometimes columns or rows have to be removed automatically. But when i remove a row or columns it gives me an error: excel found a problem with one or more formula references in this worksheet.
Does anyone know how and if this can work?
i cant make it in to a table also because when a value is deleted from the table the chart doesnt update properly (It is left half empty, and i want the information that is left to be properly distributed in the whole chart)
Thank you