• 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.

interactive chart created, but pivot chart not on auto

Prinz Jaymes

Prinz Jaymes

Member
Hi
I created an interactive chart, and to deal with zeroes or unnecessary blanks not showing up on Chart, i used a pivot table and chart.
However, my interactive hyperlink chart does not update unless i click refresh ' data' in data menu

Any way to bypass refreshing everytime?

Luke and Narayan helped earlier on this issue, but pivot
 

Attachments

Hi Prinz,

See the attached file. I had changed two things in the file, the refresh code which was assigned to a button earlier now is being executed when the range projectoption changed on calculation sheet through worksheet change event.

Second has nothing to do with your query, I had apply word-wrap to cells where you had put highlightseries function. This will help when you hover your mouse on any part of the cell, otherwise you have to hover over the down arrow only. Change it and see the effect change.

Regards,
 

Attachments


Somendra
Thats a much needed progress. Thank you Ninja!!

Any chance you may know how to prevent Pivot fields from being "unchecked"?
Sometimes, when I hover over the hyperlink cells, pivot takes out a much needed field on my chart.
 
You must log in or register to reply here.
Back
Top