some problem in showing chart legend

[afshin]

I have a one chart in a report, that in legend of chart I want to show date(readdate field).when the dates(readdate field) is more than one date I don't have any problem but when date(readdate field) is only one date, in place of date field, legend show other field(level field).
row source of that chart is:
TRANSFORM Avg(Q1.SumOfIDispA) AS AvgOfSumOfIDispA
SELECT Q1.level
FROM (SELECT AllSumation.readdate, AllSumation.level, AllSumation.SumOfIDispA, AllSumation.INC FROM AllSumation WHERE AllSumation.INC= 'IS-11-4 ') AS Q1


GROUP BY Q1.level
PIVOT Q1.readdate;
Attachment file a: one date
Attachment file b: more than one date

[June7]

I have to work with data to analyse graph issues. If you want to provide file, follow instructions at bottom of my post.

[afshin]

your instructiones don't realation with my question.

[June7]

I never encountered such a graph issue and have no idea why the report is behaving like that. Best way for me to analyse graph issues is to work directly with data and report object. How is that not related?

[afshin]

in attached file,i have a one report that show legend level field in place of readdate field.(when i have only one date)

[June7]

Only thing I can conclude is that is how the graph engine deals with plotting a single series. If the plot will be limited to a single readdate, the legend is not needed. I have many graphs that plot single series and I don't show legend on any so this never occurred as an issue to me.

Don't see any way to format the graph to deal with this. If you must dynamically allow for single or multiple readdate then suggest using VBA code to manage display/nondisplay of legend.

BTW, apparently Level is an SQL reserved word. Advise not using reserved words as names.