• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Scrollable XY scatter chart (x categories not scrolling)

Hello,

I have some sine waves plotted as an XY scatter plot. I have a scroll bar pointing to an OFFSET function in my source data that the graph is based on. When I click the scroll bar, the days (1, 2, 3, 4, etc. on the x axis) and the Y axis values scroll up and down just as they should. So far no problem. So the scrolling on my source data is fine.

The sine waves scroll across of the graph which is also ok.

But here is the problem. When I scroll across time, while the sine waves scroll across, the categories on the X axis remain still. They should be moving along with the sine waves.

What could be the cause of this?
 
DashboardNovice

It sounds as though you have fixed catgeory names rather than the range linked to a range that moves
Are you able to post a sample file with your data so we can see what you have done
 
Hi DashboardNovice,

See the attached file. Are you looking for this?

Regards,
 

Attachments

  • SineWaveScrolling.xlsm
    39.4 KB · Views: 27
Back
Top