Defining Date Formats for Line Chart

[dpatrickcollins]

I am using Crystal 9 and am creating a LINE chart; the ON CHANGE OF is month, and the SHOW VALUES are two fields, one storing a value to be counted, and the other storing a value to be summed. The line chart simple plots a line for each value by month. Question: is there a way to change the format of the month field, which appears at the bottom of the graph for each month, i.e. along the horizontal axis?

 

[synapsevampire]

In 8.5 (and possibly 9), run the report and select Analyzer->Chart Analyzer

Analyzer->Format Chart->Group Axis (tab on the left)->Labels->Select Stagger Labels.

-k

 

[dpatrickcollins]

Thanks sv. But is there a way to change the "date" format of the date fields, i.e. "mm/dd/yyyy" to "mmm dd, yyyy" or variation thereof?

 

[Dan3D]

Right click on Chart and select "Chart Options -> GRID".
Then select the Y1 Axis tab on the left. Now go to the NUMERIC FORMAT tab up top. Set format to DATE and then use the combobox to choose a specific date configuration.

-Dan @ 3D


Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com

 

[dpatrickcollins]

Thanks, Dan. But it did not solve the problem. There is no "Y axis." There is a "Group Axis" and a "Data Axis." The "Data Axis" corresponds to the numeric values, in the case of my chart, the revenue totals. By my estimation that would be the "Y" or "Vertical" axis. But the "X" or "Horizontal" axis is where the dates appear. There is no tab for this. Really frustrating. Any more thoughts?

 

[manifester]

I too have the same problem...did you find any resolution to this? Or just frustration? Much appreciated.

 

[dpatrickcollins]

Hi Manifester,

Answer is no. I am a little fuzzy on the details of the question I originally asked here since it has been so long, but no, I did not find an answer . . .

 

[lbass]

You could create a text formula (here it is based on a monthly grouping):

totext(date(year({table.date}),month({table.date}),01),"MMM dd, yyyy")

...and use this as your "on change of" field--although you will then have to use specified order to get the correct order. Or you could change it to:

totext(date(year({table.date}),month({table.date}),01),"yyyy/MM/dd")

Then you will get the correct order, but it sort of defeats the purpose of converting the field in the first place.

-LB

 

[pills]

Hi dpatrickcollins, I am facing the same issue now. Had you solve this issue ? If so, please share with me as well.

Thanks