Forum Discussion

superdorma's avatar
superdorma
Copper Contributor
Nov 28, 2019
Solved

Selecting nonadjacent cells in Excel Web for a Chart

Hi,

 

I noticed that when I Select Data for a chart in Excel Web, the web version of Excel does not allow me to select nonadjacent cells for my chart. Is there a workaround for this, or is this just how it is?

 

https://support.office.com/en-US/Article/Select-data-for-a-chart-5fca57b7-8c52-4e09-979a-631085113862#ID0EAACAAA=Windows

 

I guess the Web Excel is just not as fully featured as Windows Excel, ha. Even when I try manually changing the data range in Select Data, Excel Web changes it back to a range of adjacent cells anyways. I manually typed in an equation based on the below info, but no luck.

 

https://www.extendoffice.com/documents/excel/761-excel-select-non-adjacent-cells-ranges.html

1 Reply

Resources