Log In
Register
Home
August 20, 2020
Offline
Hello "MyOnlineTrainingHub" so far I've been teaching myself Excel with a lot ! of your videos.
But now, I found myself against the wall.
I would like to insert a Sparkline in Sheet named "Summary" in the yellow highlighted cells using the data from the Pivot table in sheet named "Pivot Table".
I could do this manually (assuming I have no trouble taking my time), but what I'm afraid of is that if later on I add or change the order of my ROW LABELS in PIVOT TABLE, my sparkline changes given the fact that I entered the data range manually.
My months would always be 12 (Jan to Dec) but maybe my "Category2" values in ROW LABELS may change.
I've seen your video from https://www.myonlinetraininghu.....med-ranges, but I could not quite grasp the full concept of it. I may be doing something wrong, So I created this file and hoped to shared it with you.
Sorry if I'm repeating or duplicating topics, but I'm quite sure you will help me out or forum members.
At least I've high hopes on.
Thnx
PS: Sorry for formulas in file. I've to quickly create this file since the original is way bigger and in a foreign language that maybe not all would understand.
See Answer
July 16, 2010
Offline
Hi Javier,
Welcome to our forum. Please attach your file again and this time be sure to press the yellow 'Start Upload' button.
Mynda
August 20, 2020
Offline
Sorry ! .. I'm attaching it correctly this time.
July 16, 2010
Offline
Hi Javier,
Thanks for sharing your file. The formula in my example expects the Sparklines to be on consecutive rows. Your Sparklines have two spare rows between each one.
Therefore, you need to use a different formula e.g. select cell A6 on the Summary sheet and name this formula for your Sparklines:
=INDEX('Pivot Table'!$B$4:$M$8,MATCH(Summary!C6,'Pivot Table'!$A$4:$A$8,0),0)
This will allow you to place your sparklines on non-consecutive rows.
Mynda
Answers Post
1 Guest(s)
