Forum

Hi Ndalowa, Please see the file attached. Note: you may want to consider fixing the vertical axis so they're all the same using a ghost series. ...

Hi Melissa, I doubt you can collate your data in a tabular layout from the get go, as it probably comes from a survey system that puts it in this f...

The image attached is actually 3 separate charts. You cannot have one chart with the vertical axis restarting at zero part way up. If you want them in...

Hi Heleen, In the file attached I used Power Query to number grouped rows. I had to add Table.Buffer to the Sorted Rows step because the sort order...

Hi Robert, Welcome to our forum. It's not clear what you mean. Please upload a small sample file containing your data and desired result. Myn...

Hi Rosemary, I understand that the spaces in the middle of the text string can vary, but do they always have the same number of leading and trailin...

Hi Cathy, If your data is stored in an Excel Table then you should be able to Refresh All and have all PivotTables pick up the new data. Rather tha...

Hi Melissa, 1. To view the field list, right-click the PivotTable > Show Field List 2. Yes, just click the Refresh All button on the Data tab...

It doesn't matter what the location is of the source data, Excel Online has no refresh functionality, so the only option is to refresh from the deskto...

Hi MJ, Someone else asked this the other day. In Power Query you cannot establish whether a process is more or less efficient based on the number o...

Hi Madhuri, In Excel you can use this formula: =IF(J2="","",IF(J2>=H2,J2-H2)) In Power Query change the data type for the schedule start, ...

Hi Madhuri, Welcome to our forum! It's great to hear you're having some success building your own dashboards. The forum is here to help you if ...

Hi Victor, Welcome to our forum! Thanks for sharing your file. I was able to refresh the query without any issues. I suspect it may be something...

Hi Melissa, Yes, you need to unpivot your data, but this is easy with Power Query: You can then use Show Values as > Percentage of Parent Co...

Hi Bob, Welcome to our forum! It looks like cell names with workbook scope trump names with worksheet scope even though the hyperlink definition on...