Forum Discussion
charts
how do i increase the data range for a chart
6 Replies
Hi salsequim
there are several ways to do this.
- edit the chart and adjust the data source manually
- convert your source data into an Excel table and use the table or its columns as the chart source
- create a named range with a formula that calculates the range dynamically and use that name in the chart source
I am using online excel and i can't do any of the things you suggested.
Hi salsequim
You can create two of the three suggestions in Excel online and the third suggestion can be set up in Excel for desktop and will work fine in Excel online.
1. change the chart manually:
In Excel Online, select the chart and on the Chart ribbon select the "Select Data" command. Here you can change the range that the chart refers to. This works for data layouts in one contiguous range.
2. using an Excel table
Select the data and use the ribbon command Insert > Table. With the table selected, insert a chart. When new data rows are added to the table, the chart automatically includes these data points.
3. Set up dynamic range name formulas and connect them to charts in Excel for desktop. Then you can use Excel online to add new data and the charts will update automatically.
Some more sophisticated techniques, like dynamic range names, can only be configured in Excel for desktop, but once they have been set up, the will work in Excel online as well.
