P
PaB
I have a chart created from a query that has four sets of data, an expression
to create a "goal" line, and another set of data that I want to use to add a
trendline to the chart. When I open the chart I see all six lines, but when I
want to format the chart and go to design view all I can see is the four
lines from the four sets of data. Another problem is that when I click to add
a trendline the data set that I want to create it from is not available in
the series selection box. Can any one tell me what I might need to do to be
able to add the data series for my trendline and also to format the goal and
trendline?
to create a "goal" line, and another set of data that I want to use to add a
trendline to the chart. When I open the chart I see all six lines, but when I
want to format the chart and go to design view all I can see is the four
lines from the four sets of data. Another problem is that when I click to add
a trendline the data set that I want to create it from is not available in
the series selection box. Can any one tell me what I might need to do to be
able to add the data series for my trendline and also to format the goal and
trendline?