Adding Extra Data Field in a Chart

[Guest]

Hi all,

I'm having the hardest time getting a chart to display the data in the
format I want. So I'm hoping someone can help me with it.

When using the wizard, I want to have 2 data fields while using a series and
axis.

The bottom access if the Date (by month) and the Series is Area Number
(which means Store Number, essentially).
The two data Fields are Min and Max of a field (called Try).

Because I can't have 2 data fields, I use just one in the Chart Wizard to
start the chart. The data is retrieved from a query and the row source
becomes:
NSFORM Sum([MinOfTRY]) AS [SumOfMinOfTRY] SELECT
(Format([MaxOfDTL_DATE],"MMM \'YY")) FROM [tempqryTry] GROUP BY
(Year([MaxOfDTL_DATE])*12 +
Month([MaxOfDTL_DATE])-1),(Format([MaxOfDTL_DATE],"MMM \'YY")) PIVOT
[AREA_NUM];

I basically want to add Sum([MaxOfTRY]) somewhere, but I don't know how. I
tried numerous positions and kept getting errors.

When looking at the chart, I want two bars for EACH Series. And numerous
SERIES for each MONTH.

It'll look complicated, but that's what I'm looking for.

If anyone can help me, it'd be very appreciated. I'm so utterly stuck.

Thanks,
Jay

 

[Guest]

Disregard my question, they've decided to completely change the charts used,
so it's irrelevant now.

Thanks,
Jay