Denne nettleseren støttes ikke lenger.
Oppgrader til Microsoft Edge for å dra nytte av de nyeste funksjonene, sikkerhetsoppdateringene og den nyeste tekniske støtten.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am experiencing that one of my spreadsheets all out of a sudden has become extremely slow at rendering charts.
The symptom: Whenever I zoom in or out, or makes changes to some of the charts, the spreadsheet freezes (including vbe-macro tab) for 20-30 seconds (!), and that is per action made by me.
Previous editions of the sheet would load this is less than a second. I can always just go back to those versions, but it is incredibly that this happens all out of a sudden with none known fixes:
https://answers.microsoft.com/en-us/msoffice/forum/all/chart-rendering-in-excel-365-has-dramatically/b687b78f-f81e-4004-a425-72b3320c4df5 https://www.reddit.com/r/excel/comments/62l0j7/problem_in_excel_2016_when_rendering_multiple/
I think what triggered this was that I changed the background colour of all the charts (ChartArea) to white.
En familie med Microsoft-regnearkprogramvare med verktøy for å analysere, kartlegge og formidle data.
Låst spørsmål. Dette spørsmålet ble overført fra Microsofts kundestøttefelleskap. Du kan stemme på om det er nyttig, men du kan ikke legge til kommentarer eller svar eller følge spørsmålet.
I found the reason, I was adding series by selecting cells and then select by .xldown,
so a few series (by mistake) included several millions of cells and this slowed down everything exceptionally.
Sorry for the inconvenience, and thank you for the help anyway!
Hello Hallvard
I’m Adeyemi and I’d be happy to help you with your question.
There could be several reasons why chart rendering in Excel 365 has become slow. Some users have reported that chart rendering has slowed down after an update. You could try launching Excel in safe mode and see if the issue persists. If it doesn't, you can try disabling add-ins to see if that resolves the issue. Reference: https://answers.microsoft.com/en-us/msoffice/forum/all/chart-rendering-in-excel-365-has-dramatically/b687b78f-f81e-4004-a425-72b3320c4df5.
Another user reported that charting became slow when the chart styles option was enabled in the chart formatting ribbon. They found that collapsing the ribbon improved performance.
If you feel that this should be classified as an issue, you can report it to Microsoft through Excel's feedback option here: https://support.microsoft.com/en-gb/office/how-do-i-give-feedback-on-microsoft-365-2b102d44-b43f-4dd2-9ff4-23cf144cfb11#platform=Windows
I hope this information helps!
Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below
Regards, Adeyemi
Changed this to a subanswer, as this is probably is not so related to why. it is rather an explenation to why I changed the background colours:
It is because some of the charts had turned transparent (not specified/triggered by me, but rather "a unwanted trigger" by the macro code (written by me).
I have checked the macro code thouroughly with F8:
Only one chart is supposed to transparent in the sheet, as I make png/gifs out of a chartobject with a few charts embedded (as it is not possible to draw png-s from a selection of charts).
However, that code alters a few "completely other" charts as well simultanously (which are not selected/activated by me (have chekced with F8)) => Seem to be rather that several charts is given the same ID (names are always different, so rather something else, like ChrtObj-Number or something similar), even though I only choose one specific.
This has also happened to me earlier in excel-vbe where two properties or objects may be activated and altered simultanously,
e.g. A) "line style" of both 1) chartserie lines and 2) -markerlines can be changed simultanously, or
B) two series are given the same format even though only one is chosen... (E.g. as discussed here: https://answers.microsoft.com/en-us/msoffice/forum/all/changing-color-for-one-data-series-changes-color/56add894-36b6-40b6-9c99-300df914a0c9 => The fix is to start all over again, and don't use copied charts in that case...)
C) etc.