MashZone Y-Axis and Excel 2003

I am unfamiliar with different versions of Excel's data format but I connot see any differences between 2002 and 2003 and I don't think this affects your problem.

Based on the image you posted I assume that the data feed column that provides values for the horizontal axis is of type Text. The reporting period reads 2009.0-1.0.

Please note that formating is aplicable to typed values only. E.g. to print only year and month of a given value of type Date MashZone needs to understand that this is a date. You can easily ensure your values are typed correctly by inspecting the column header icon within the data feed editor's debug output:

To present your data properly I may suggest that you make use of the operator Columns > Change data type. Your pattern seems to be yyyy.M for the starting of the reporting period.

Stephan,

Thanks for the response. The column type is number as indicated in the image provided below. I realized the Fiscal Period is incorrect but am not concerned about that right now. Also note that the values are formatted correctly in the image as numbers. In the Excel file the numbers appear properly as well as shown in the second image I am attaching.

As for the Excel issue with the SalesForce export files I will be glad to mail you a sample directly to your IDS Sheet account if you wish to review. My SoftwareAG email is my user name.

Thanks

Yes, the numbers should be detected automatically. But is your column named "reporting period" typed with date/time? I think this is the issue described at the beginning.

Please feel free to contact me at me via email or phone.