i have a scatter chart in attached file, when a row is added to "sheet1" i should re-arrange the source data of chart.
how can i make source data of chart without any needing to re-arranging of that when some row added to "sheet1"?
i have a scatter chart in attached file, when a row is added to "sheet1" i should re-arrange the source data of chart.
how can i make source data of chart without any needing to re-arranging of that when some row added to "sheet1"?
About the best I can do is give you a button that adds the series. Highlight the row of data you want to add on Sheet1 and then click the button. The series will be added to the chart.
To remove the test series. Right click on the chart, select Select Data, scroll down to test and select it and click on the remove button.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
With special thanks.
I thought, should I use dynamic chart.
I attempted to use dynamic ranges and even Excel Tables, but I did not seem to be able to get it to work. I've found that when I build a chart based on a table, that if I add a new column to the table, it adds the new column as a series. That works for bar and line charts. I could not get it to work for the scatter chart.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks