Having trouble with charts updating in Excel

**ExcelNUBs** · 04-23-2012, 11:42 AM

Has anyone ever had a problem, when you calculate the page with new data. The data points on the chart do not change either? This has happened to me a couple of times in the past. The long fix is turning my computer off, restarting excel doesn't cut it. Is there a quick fix? Is it a bug?

Thanks for your time.

**dilipandey** · 04-24-2012, 02:45 AM

Hi ExcelNUBs,

when you calculate the page with new data. The data points on the chart do not change either? T

So you are saying when you enter new data in excel OR you calculate (F9)... the data point for chart do not change?
Do you have excel calculations set to automatic?
Upload the sample workbook to enable forum members to do more research. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**ExcelNUBs** · 04-25-2012, 09:58 AM

It is saying the file is to large. I am trying to take out what you don't need to see

**ExcelNUBs** · 04-25-2012, 10:08 AM

Okay, so the best way to describe this is:

The data that calculates on the right (Columns N-Y) are not refreshing the chart when you calculate the page, so the chart on the bottom is keeping the old numbers/data points. However the numbers in columns N-Y are the new numbers. I have to completely log out of excel and restart my computer.

It is very hard to give you a full file, mainly because of size and company policy. These are all filler numbers and fake data. I just wanted to give people an idea of what I am looking at.

I had to cut a lot of formulas for this file to upload it.

Attachment 152358

**dilipandey** · 04-25-2012, 01:00 PM

Hi ExcelNUBs,

While trying to download the attachment, I got the message "Invalid Attachment" ...

Regards,
DILIPandey

<click on below 'star' if this helps>

**ExcelNUBs** · 04-25-2012, 01:38 PM

Hope this works sorry.

Book1 Chart.xlsm

**dilipandey** · 04-26-2012, 12:55 AM

Hi ExcelNUBs,

I found the same issue as I highlighted in my post #2, point no.2.. the calculation mode was set as Manual mode.. .. follow the below steps to correct. thanks
Go to File -> Options -> Formulas -> Workbook Calculation -> Automatic

Regards,
DILIPandey

<click on below 'star' if this helps>