Link to home
Start Free TrialLog in
Avatar of sofiabas
sofiabasFlag 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
Avatar of ScriptAddict
ScriptAddict
Flag of United States of America image

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.
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
Avatar of sofiabas

ASKER

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

Thank you
Sample-Chart.xlsx
ASKER CERTIFIED SOLUTION
Avatar of ScriptAddict
ScriptAddict
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial