Nov 28 2019 09:37 AM
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?
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
Nov 28 2019 12:05 PM
SolutionThat's how it is. Excel Online has limited functionality compare to Excel Desktop.
Nov 28 2019 12:05 PM
SolutionThat's how it is. Excel Online has limited functionality compare to Excel Desktop.