Forum

I feel like there should be something simpler using HSTACK and WRAPCOLS but it eludes me at the moment. Something like this should work - adjust the 5...

If you really wanted to pursue it, one option might be to create arrays with related colour values in (eg one has colour values for the line, one for ...

Unfortunately there is no option in VBA to simply apply a theme to a sparkline. You have to individually set the colours of the line, marker, high poi...

I don’t really understand. One code adds and formats spark lines while the other only adjusts the location and data range of existing spark lines. It ...

I didn’t say that Chr and ChrW are the same. I said that both expect a number to be passed to them, not a string.

That routine replaces the previous one of the same name. The worksheet code that calls it remains the same. as long as there are spark lines o...

I do like the idea of a sparkling sheet! 😉 If you already have the sparklines in place, then the code can be a lot simpler: Sub UpdatePivo...

IMO you would be better off converting the dates to the 1st of the month so that you can use them as dates in calculations. You can always format the ...

Not a big deal but just so you know: Chr (like ChrW) expects a number, not a string, so by passing strings you're actually making it do unnecessary wo...

You should be able to just wrap another IF: =IF([Amount]<>0,IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EA...

Private Sub Button26_Click(sender As Object, e As EventArgs) Handles Button26.Click That is VB.Net code by the way, not VBA.

If I understand correctly, you could use this: =IF(COUNTROWS(FILTER(Table1,[Invoice]=EARLIER([Invoice])&&[Branch]=EARLIER([Branch])&am...

You can also do it with code. Add this to a normal module: Sub UpdatePivotSparklines(pt As PivotTable) With pt Dim sparkRange As Range ...

FYI, cross-posted here:

Also cross-posted here: