ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Number format changes in chart after closing and opening (https://www.excelbanter.com/charts-charting-excel/145825-number-format-changes-chart-after-closing-opening.html)

Kmysings

Number format changes in chart after closing and opening
 
when i close my worksheet to save, i reopen it and my number formating within
the data table portion of the chart has changed. For example from $ to %.

Bernard Liengme

Number format changes in chart after closing and opening
 
I have not seen this happen but here's something to try;
Format the Axis; on the Numbers tab there is a box "linked to source"; click
this to remove the check mark
See if this helps and let us know
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Kmysings" wrote in message
...
when i close my worksheet to save, i reopen it and my number formating
within
the data table portion of the chart has changed. For example from $ to %.





All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com