Clumsy Graph from Powerpivot .Help to add Scroll bar..

[dheeraj1688]

Hi,
i am facing a problem .After Getting data from poverpivot .my graph is too much MESSY..Even i stretch the graph ..
can anybody help me ,how can i add scroll bar in graph as this is generating from pivot table.Attaching file for ref.

Thank in advance.

 

[Nebu]

Try to plot a scrolling chart , here is an example
http://www.andypope.info/charts/Scrolling.htm

thanks

 

[Gangadhar Yeligaty]

Hi Dheeraj,

step by step explanation for linking a scroll bar to a chart.
http://www.spreadsheetshoppe.com/add-a-scroll-bar.html

Regards,
Gangadhar Yeligaty

 

[dheeraj1688]

Try to plot a scrolling chart , here is an example
http://www.andypope.info/charts/Scrolling.htm

thanks

Hi Nebu
thanks for reply.But my chart is generating from pivot table. where this method may be(as i Try manually select data it automatically select whole pivot table in chart) not working.Hope i'm able to clear my problem.

 

[Nebu]

Hi:
it is possible to get a scrolling chart from pivot using helper data set, can you please upload a sample file...

 

[dheeraj1688]

Hi:
it is possible to get a scrolling chart from pivot using helper data set, can you please upload a sample file...

Hi Nebu..
i attached the sample file,as i'm facing.I highlighted one blank cell that is so high it take graph value to higher range (same in real also).

 

[Nebu]

No file attached...

 

[Nebu]

Hi:

Please find the attached.For bigger values there some options to do split graphs, if it is absolutely necessary we can check that options as well. I have anyways done scroll chart just play around with it and let me know...

 

[dheeraj1688]

Hi:

Please find the attached.For bigger values there some options to do split graphs, if it is absolutely necessary we can check that options as well. I have anyways done scroll chart just play around with it and let me know...

Hi. Nebu
Thank you for ur reply.. it work perfectly as i wanted.Secondly i don't think i need to split the blank cell.FOR Knowledge can u tell me how to do it , it will be great help.
Anyways Thanks a LOT...

 

[Nebu]

Glad it helped , regarding your second query here is a thread where I had given a solution earlier for a similar issue
http://chandoo.org/forum/threads/charting-small-and-large-number-on-one-line-chart.20236/