vishwasexcel
New Member
Dear All
see attached file, pls help me sales dashboard with scroll bar
see attached file, pls help me sales dashboard with scroll bar
Sale dashboard
- Thread starter vishwasexcel
- Start date
Smallman
Excel Ninja
Hi Vishwasexcel
Welcome to the Chandoo forum
Your first and most pressing problem is your data layout. You will have lots of trouble getting a scoll bar working effectively without the months down the side.
When you set up your pivot tables instead of the filter being month you should have put the month as a column header and had the dates filled the far left of your worksheet.
Then you are left with two unique bits of data to work with, your month and your "Row Label", this can be used to generate your calculated fields for the scroll bar.
Also you might indicate how you want to see this. A one line question followed by data without a "what you would like to see once complete" is a bit cryptic. A bit more informaiton will help everyone.
Take care
Smallman
Welcome to the Chandoo forum
Your first and most pressing problem is your data layout. You will have lots of trouble getting a scoll bar working effectively without the months down the side.
When you set up your pivot tables instead of the filter being month you should have put the month as a column header and had the dates filled the far left of your worksheet.
Then you are left with two unique bits of data to work with, your month and your "Row Label", this can be used to generate your calculated fields for the scroll bar.
Also you might indicate how you want to see this. A one line question followed by data without a "what you would like to see once complete" is a bit cryptic. A bit more informaiton will help everyone.
Take care
Smallman
Last edited:
vishwasexcel
New Member
As your mind design chart
vishwasexcel
New Member
See Modify file with example pls assign macro
vishwasexcel
New Member
Thanks Hui
ashish mehra
Active Member
NARAYANK991
Excel Ninja
Hi Ashish / Vishwas ,
The problem is that the months have not been entered in the same cell relative to the data ; the formula should not be modified to take such variations into account ; instead the data format should be standardised.
If the month April is in A1 , and the corresponding data is in A4 onwards , this is an offset of 3 ; this same offset should be maintained for all the months ; thus if the data for June is from A55 onwards , the month label itself should be in A52 , not in A51.
Otherwise , instead of using a MATCH function to get the starting cell of the data , we can use a lookup table , where the row numbers for the first data item are stored , in which case the separation between the month label and the data can vary.
Narayan
The problem is that the months have not been entered in the same cell relative to the data ; the formula should not be modified to take such variations into account ; instead the data format should be standardised.
If the month April is in A1 , and the corresponding data is in A4 onwards , this is an offset of 3 ; this same offset should be maintained for all the months ; thus if the data for June is from A55 onwards , the month label itself should be in A52 , not in A51.
Otherwise , instead of using a MATCH function to get the starting cell of the data , we can use a lookup table , where the row numbers for the first data item are stored , in which case the separation between the month label and the data can vary.
Narayan