SOLVED

Selecting nonadjacent cells in Excel Web for a Chart

Copper Contributor

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-63108511386...

 

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
best response confirmed by superdorma (Copper Contributor)
Solution

@superdorma 

That's how it is. Excel Online has limited functionality compare to Excel Desktop.

1 best response

Accepted Solutions
best response confirmed by superdorma (Copper Contributor)
Solution

@superdorma 

That's how it is. Excel Online has limited functionality compare to Excel Desktop.

View solution in original post