Avatar of sofiabas
sofiabas
Flag for United States of America asked on

Pivot Chart with a Scrolling bar

I need to create a scrolling bar under the attached pivot chart.
The periods need to be from 1 to 50. Please provide a step by step process.
Thank you
PivotChart.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
ScriptAddict

8/22/2022 - Mon
ScriptAddict

This is how it's done:

http://www.officetooltips.com/excel/tips/creating_a_scrolling_chart.html 

Let me know if you have any problems.
ScriptAddict

I did quite a bit of testing with this.  And was unable to get this to work for my 2010 Excel.  

I'd like to recommend instead of trying to alter the chart, to alter the pivot table.  You can use a scroll bar to change a cell value just like in the above example, but then I'd recommend using something like

http://www.excelforum.com/excel-programming/746548-change-pivot-table-filter-based-on-cell-value.html

To change the vba filter on your pivot table.  When I was testing this on my system, it automatically updated my chart based on those changes.  

Best of luck,

-SA
sofiabas

ASKER
I am still  having problems with this. Can you please help me with the attached chart.

Thank you
Sample-Chart.xlsx
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
ScriptAddict

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question