Problems with Charts

Mark.B

Board Regular
Joined
Jun 14, 2004
Messages
134
So I'm building a dashboard and am working with Charts. With one of these (Line & Column on 2 axis) I change the source data programmatically, make some changes to formatting and then make the chart visible to the user.

The issue that I have is that for an instant, after changing the source data and making the chart visible, the previously selected data (and the columns that represent the previous data) is momentarily visible before the chart refreshes with the new source data. It's like an after-effect or after-image and can result in a column jumping from say 10% to 70% (albeit very quickly). It looks very 'glitchy'

I've tried various ways to work around this. One idea was to generate a new chart each time (from scratch) programmatically, so that there was no previous data to carry over when the chart is revealed. This time however, after making the chart visible and for a split second I can see what looks like a grey placeholder (a picture or an image of some grey columns) before the chart refreshes with the real data and real columns. Again its very quick but it still looks very glitchy.

Has anyone come across this before and found a wau to avoid / work around ?

Any help would be appreciated.
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,729
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
As you should know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problems with Charts
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 

Mark.B

Board Regular
Joined
Jun 14, 2004
Messages
134
As you should know by now:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problems with Charts
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Apologies, Im just trying to reach out to as many people as possible. I;m not sure what the issue whith that could be ?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,729
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If you read the rules, you will understand. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,051
Messages
5,639,773
Members
417,112
Latest member
PachRedoc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top