Cannot select chart template

Question

Hi Sir,

Do u have idea why I can't applied my templates in Excel 2016.  the error seems cannot be selected and not visible.

Answer 1

Hi Anney

My name is Jegan, would like to assist you regarding your request.

Try restart your computer and open excel again.

Have you copied your chart templates in any other destination?

the default location is

C:\Users<User Name>\AppData\Roaming\Microsoft\Templates

Also navigate to the File tab > Options > Save and enter the path to the templates folder in the Default personal templates location box:

You may also try run excel in safe mode.

In the Search Box above Windows icon, type "Excel.exe /safe" without quotes and enter.

File > Options > Advanced - In General section (go very much down in Advanced), check "Ignore Other applications that use Dynamic Data Exchange (DDE)". Close and re-start the Excel. Uncheck "Ignore Other applications that use Dynamic Data Exchange (DDE)". Close and re-start Excel again.

If nothing works

Perform Quick Repair of the office installation

https://support.office.com/en-NZ/Article/Repair...

Answer 2

Hi Anney

You also check whether your printer driver is updated. sometimes the issue due to printer setup, when a printer cant print the Graph.

Answer 3

Hi Jegan,

Good morning Jegan.  My template location is the exactly the same.  I have already did reinstalled Ms office Application and restarted the pc already.   The setting on DDE also set.   For your info, this donut chart is not a standard chart from ms excel.  As u noticed it has 2 X and y series you could entered. if you create a new donut chart, u will find only allow to have one Axis series to select data. 

I have no issue on choosing other template which originally coming from MS excel's chart and apply template.  only this Donut chart is special which could have 2 series x and y to select data. 

 Wanted to provide you the sample find this post cannot attached file.

Thanks.

regards,

Anney

Answer 4

Hi Anney

is the data has any issues? (means same format?)

Can apply another template for the same range of data?

Can you try in safe mode?

Answer 5

Hi Jegan,

Data has no issue.  just that I need to kept reformatting the same chart.

:)

Thanks.

regards,

Anney