How to change bin number/width in a histogram in Excel for Mac (Office 2020)
Hello, I have created a histogram and now I want to modify the width and number of the bins. Can someone please advise? When I select 'format axis' there is no option to modify bin (see attached). I have seen various videos and web pages that show how to do this in Excel 2016 and later, so I am confused as to why bin width/number is apparently hard wired in my Excel (2020 Microsoft 365, Excel version 16.41). Thank you for your help.
Creating Sankey Diagrams
Hi, Does anyone have any guides for creating Sankey Diagrams in Excel. I deal with the analysis of a reasonably long process which has various customer inputs and outcomes. I am looking for a visual way to show everyone who came into the process, and what happened to each person. Sankey Diagrams seem to fit that bill perfectly. Any help would be appreciated. Thanks T
How do I make a line chart ignore empty cells and NOT log then as 0?
Hello, I made a line chart and I want it to log a potential of 16 data points, but those data points will be filled in over time so I want the line chart to only graph the real-time data for the number of cells that have been entered. For example if cell 1 is 200, cell 2 is 225, and cell 3 is 250, and cell 4 is empty I want the line graph to chart 200 to 225 and then 225 to 250 and then just end at 250, NOT drop down to 0 for 4 to 16. How cand I do this in excel office 365 please. The methods I have found via google do not work. For example, I found a method to "ignore gaps", but that option isn't actually available to choose in 365 so how else can I do it please? Thank you! JayHow can I change the order of column chart in excel?
I created a table and chart, but the order in the chart starts from "E" instead of "A". I want the chart to start from A down to E. instead of E on the top and A on the bottom. Please advise how I can do that. Thank you so much for reading my question. I've attached a screenshot.How can I show percentage change in a clustered bar chart?
Hell, I have a graph showing the sales change from one period to the other (1qtr 2021 to 2 qtr 2021) and I would like to sisplay the percenatge change from one period to the other. For example for "Car 1" the sales wnt down 12% (-12%). For Van 3, it went up 48%. Is there a way to show this in the bar chart?
I need help with adding trendline and finding the r squared value
For my biology class, I had to conduct an experiment and put down all my information on excel. I had to put in all the data and create a scatter plot, after i did that I had to add a trendline and then find the r squared value. I don't know if I'm doing it wrong or something is wrong with my version of excel, but I desperately need help.
