ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Date format change when using Series() function (https://www.excelbanter.com/charts-charting-excel/166252-date-format-change-when-using-series-function.html)

NM

Date format change when using Series() function
 
Im using the Series() function with graphs, and the name ranges within the
graphs seem to work, however, the X axis date range now goes weird on me.
The named range for my X axis looked fine before, but when I put the name
range in the Series, the dates are now all wrong (1/1/1900, 2/1/1900, etc).
Any thoughts?

Thank you.


All times are GMT +1. The time now is 06:03 AM.

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