Hello, I have an object (=A1) when I try to insert new data into the already customized object the style changes back to default (wrong letter size, wrong color, wrong font,)
How to turn this feature off?
Thanks
https://www.youtube.com/watch?v=2E7iRSb4aFg
Last edited by sovietchild; 04-18-2017 at 02:58 PM.
How are you inserting the new data?
If posting code please use code tags, see here.
=Sheet1!$G$14 into the new object inside of the chart, the code is correct but the style changes to default, if you can tell the style is 77% when I copy the chart, it looks the same but when I change the coding the style changes to default (wrong font, small font, wrong color)Originally Posted by Norie
The reason I'm asking this is because I have a lot of objects that needs to be changed to a new data. The objects are customized and the customisation does not lock on and changes back to default when new data is inserted (default color and font).
Last edited by sovietchild; 04-18-2017 at 02:21 PM.
Sorry, I'm not quite following.
When I change the value in G14 the style is retained.
Also, there's no code in the workbook.
I made a video of it. Sorry for bad quality, I can't figure out how to upload HD
https://www.youtube.com/watch?v=2E7iRSb4aFg
So you are copying the chart, setting up a new link and that's when you lose the formatting/style?
Exactly. I was able to figure out how to keep the style of the chart, by going through options, but I can't figure out how to keep the same style of the objects.
The reason I'm asking this because I have like 50 objects that needs a new data. It's such a hassle to go back and redo the font, color and the size x 50 times.
There is an option to turn this feature off for charts Options>Advanced> Chart>Properties follow chart data point for current workbook
But I can't find the same option for objects
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks