Forum

Hi James, I'm not sure what you mean by 'the Gantt chart area to the right' as there was no placeholder column in your file to indicate where exact...

Hi John, A couple of options: 1. use Excel forms to capture the information from the various users. 2. Try Office Scripts instead of VBA. Off...

Hi Kenneth, You need to create a custom PivotTable style for the header rows. Choose a style that's close to what you want, then right-click > d...

Hi Christine, Yes, Power Query can fix these dates. It looks like this might have been a text or CSV file that you've opened in Excel? I say this b...

Glad you got it working, Rob.

Hi Miguel, Each series is effectively 2 series, one for the line and one for the labels. If you open the Select Data Source dialog box (right-click...

Hi Miguel, Change the chart type to 'Line chart with markers'. Not scatter and not stacked line chart. Then add/edit all of the series to point ...

Hi Miguel, Thanks for sharing the file. You need two or more points to draw a line. If you look at series 1, you can see it references cells AC1...

Hi Miguel, Welcome to our forum. The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey c...

Hi Robb, Thanks for the file. Your data is in the wrong layout. You need to unpivot the values in the Table_Measure table. You shouldn't have s...

Hard to say without seeing how your data is structured and the PivotTable layout. Have you tried using just =DIVIDE(Table_Measure[isfrn], Table_Measur...

Hi Lisa, You just need to add a column to the source data and chart for the balance of 950 and change the chart type to Stacked Column. See file at...

Hi Lisa, The images uploaded, but the Excel file didn't. Please try again and wait for the grey check mark to appear beside the file size after pre...

Hi Rob, That's a lot to try and visualise and as a result, I'm not sure I completely understand the scenario. For one, I don't know where the sourc...

Hi Charles, This post covers the different merge types in Power Query and should answer your question. If you're still stuck, come back with an exa...