I'm plotting charts and shapes.
In let's say 6 out of 10 times, whatever I plot, stays invisible, until I zoom in or out.
Is anybody experiencing anything similar?
Is there a workaround?
Thanks!
Operating System:
OSX El Capitan 10.11.6
Excel for Mac:
16.16.27 (201012)
Last edited by 6StringJazzer; 04-16-2024 at 07:40 AM.
Please attach a sample file that demonstrates what you are seeing. See yellow banner at the top of the page.
Sorry, of course.
The attached workbook contains several Modules to plot
1. charts
2. frames as buttons (transparent, with a red line for now) to highlight chart data
3. "guidlines"
Issues:
1. plotted objects stay invincible. Only zooming in or out will let them show up.
2. plot positions vary. Depending on the zoom level, chart areas and plot areas jump.
I've managed to find the "right" zoom level to plot each chart by trial and error.
And I've added these "working" zoom levels to each create chart macro:
This helps, but doesn't always work.
Please Login or Register to view this content.
I've also tried to use
Didn't notice any different behavior.Please Login or Register to view this content.
Thank you!
I opened the file and the zoom was at 90% on the sheet. I could see all the charts without changing the zoom. Is your experience that you open this file and the charts are invisible*?
*Not "invincible"
No, if everything is done, everything is fine!
It happens, while I'm plotting.
Last edited by briskie; 04-15-2024 at 11:03 PM.
Just looked up "invincible".
Yes, "invisible".
Thanks!
Last edited by briskie; 04-15-2024 at 11:04 PM.
How do I reproduce this? Do I just run your VBA Subs to make the plots? Do I have to delete existing plots first before I run the code?
Please have a look at the new version, it now has buttons for every item, so you can just use these to plot and delete.
To have a reference, I have renamed the existing charts (chart name + "Original"), so that they are not affected by the buttons.
Also for test purposes, I have turned off (or should I say commented?)
in all create chart macros.Please Login or Register to view this content.
The screenshots show: If I don't stick to the zoom level I found by trial and error, the chart is plotted in a slightly different area.
Last edited by briskie; 04-16-2024 at 06:33 PM.
The code fails because the sheet is protected with a password.
Oh, yes. It's "pw".
The chart names in your code don't match the actual chart names on the sheet. I manually deleted them then clicked the buttons to redraw.
I am getting a gray placeholder instead of a complete chart. Not invisible, but not right either. Needs more research.
charts.jpg
Yes, that's right. I purposely renamed the "original" charts, so that they would stay unaffected by the buttons.
I did this to have a reference, to see, how much the plot is off, when plotting at a zoom level other than the one that works.
For the meantime, I also set the charts area's fill to transparent to use the gridlines as temporary guidlines.
The macros to create a chart are from different sources, I'm still learning, how to merge them.
So for now, it's step by step, one macro for each step: create, color, label, frame.
So to plot a chart, you would need to press the buttons one after another.
It is also correct, that the charts are grey at first. I also did that on purpose to start with a neutral fill before applying the colors.
Could you maybe just plot the first chart at a zoom level other than 110% and see, what happens?
Does it exactly cover the original chart? Or is it off, like in my screenshots?
And could you maybe check "Add Guidlines" and "Frame A" an see, if they appear, without having to change the zoom level?
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks