In Windows version of excel it is possible to select/deselect chart series/categories by clicking a box in the 'select data' dialogue window - this functionality is not available on Mac.

The function is incredibly useful when regularly processing similar data sets but not always needing all categories (i.e. tailoring a charts in a template sheet).

Please introduce it! Generally I much prefer Excel for Mac but for me the lack of this function is a major weakness.

Screen grab of the function in Windows Excel attached.

in Win version, there is checkbox in the data series window however not in Mac. This feature would be helpful especially when you have several data series and you want to display only some of them for comparison. Else the plot becomes too busy and hard to see between series with similar data. Right now the only way perhaps is to make another plot.

The object in the excel has dimension with height as 3.81 inches and width as 4 inches keeping the view at 100%, with respect to the said information - the height and the width don't match the said specifications at 100% as for your clear understanding I've highlighted it with red.

Please note - the display is working perfect with object dimensions when I'm working with any of the other programs eg. Adobe photoshop, All illustration programs, etc

The object in the excel has dimension with height as 3.81 inches and width as 4 inches keeping the view at 100%, with respect to the said information - the height and the width don't match the said specifications at 100% as for your clear understanding I've highlighted it with red.

Please note - the display is working perfect with object dimensions when I'm working with any of the other programs eg. Adobe photoshop, All illustration programs, etc

The object in the excel has dimension with height as 3.81 inches and width as 4 inches keeping the view at 100%, with respect to the said information - the height and the width don't match the said specifications at 100% as for your clear understanding I've highlighted it with red.

Please note - the display is working perfect with object dimensions when I'm working with any of the other programs eg. Adobe photoshop, All illustration programs, etc

Bug in Excel for Mac ver 16.49 (21050901). When making a scatter diagram (X-Y plot), the app drops out of X-Y mode, and into line chart mode when the first blank data point is encountered. the work around is to hide the blank/missing data points.

An asian baby

I do a lot of XML mapping (import XML data to Excel, Export XML format) and every time I have to do this, I need to go Windows machine, which, for those who doesn't know, is a terrible experience by itself. There is a reason I love Mac. Please make Mac the only computer that I'd be using for any need.
Thanks,

I want to be able to create a trendline more freely, where I can choose which data points in my series I want to include in the trendline. The easiest way would be to mark the points by ctrl or cmd and choose wanted data points and then create a trendline.

im selecting the recommended chart but its not coming up. what should i do?

Please add bin option on mac

Please add bin option on mac

Hi,

I am working on a workbook that I've had for years, but for some reason I am unable to make charts all of a sudden in that workbook, but I can create charts when I copy the data to a new workbook.

Your help is greatly appreciated.

Why is that?

To improve comprehension of chart data, it is sometimes very helpful to explain what each data series represents. E.g. if the series names say "orange", "apples", and "bananas" the legend could say Fruit [lbs].
While this information could be added in the chart title, it can make that title too long.

Make the secondary axis work the same on Mac as it does on PC. It is a right pain to get a secondary axis onto a graph in Mac.

Add filter option for series in a chart. Similar to what is available on Excel for Windows.

make longer slots

I've been working on a school assignment where we need to show the correlation between 2 sets of data but the range of them both is far apart. On the support page I saw the function only works in Word. Why?

My suggestion is that this function in also added to Excel.

Link:
https://support.microsoft.com/nl-nl/office/een-secundaire-as-aan-een-grafiek-toevoegen-of-hieruit-verwijderen-in-excel-91da1e2f-5db1-41e9-8908-e1a2e14dd5a9