Forum

Great idea! Thanks for sharing.

Hi David, If I understand correctly, you want a running total. See this tutorial on running totals in Power Pivot. You could also try using the...

Hi Sue, Unfortunately, there's no way to copy the formatting when you use 'show report filter pages'. The macro will be the way to go. I would ...

Hi Brian, Welcome to our forum! You can use the INDEX function to return an array. In your formula it would look like this: =FILTER(FILTER(tb...

Hi James, You can use this formula to put the resource value in the Gantt cells: =IF(MEDIAN(K$17,$C18,$D18)=K$17,$J18,"") You'll need t...

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...