Forum Discussion
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
That's how it is. Excel Online has limited functionality compare to Excel Desktop.
1 Reply
- SergeiBaklanDiamond Contributor
That's how it is. Excel Online has limited functionality compare to Excel Desktop.