Friday, March 9, 2012

plot data as line option

I have a bar chart that compares data across two dates. These dates are
passed in as parameters. Currently these are displayed as bars but i'd like
the first to be shown as a line. The query groups by date.I assume you have two data series in the chart. Right-click on the chart to
open the chart properties dialog. In the chart properties dialog box, click
the Data tab. In the Values list, click the one data series you want to show
as line, and then click Edit. In the Edit Chart Value dialog box, click the
Appearance tab. Click to select the "Plot data as line" check box.
You may also be interested in a related KB article:
http://support.microsoft.com/kb/842422
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Melissag" <Melissag@.discussions.microsoft.com> wrote in message
news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
>I have a bar chart that compares data across two dates. These dates are
> passed in as parameters. Currently these are displayed as bars but i'd
> like
> the first to be shown as a line. The query groups by date.|||Hi Robert,
At the moment i have a single data series: date derived from a group by date
in the query. How would i go about created two data series one for each date?
Thanks,
Melissa.
"Robert Bruckner [MSFT]" wrote:
> I assume you have two data series in the chart. Right-click on the chart to
> open the chart properties dialog. In the chart properties dialog box, click
> the Data tab. In the Values list, click the one data series you want to show
> as line, and then click Edit. In the Edit Chart Value dialog box, click the
> Appearance tab. Click to select the "Plot data as line" check box.
> You may also be interested in a related KB article:
> http://support.microsoft.com/kb/842422
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Melissag" <Melissag@.discussions.microsoft.com> wrote in message
> news:1DDFCCAE-3BD6-4BBA-AF10-CE2201A66BD0@.microsoft.com...
> >I have a bar chart that compares data across two dates. These dates are
> > passed in as parameters. Currently these are displayed as bars but i'd
> > like
> > the first to be shown as a line. The query groups by date.
>
>

No comments:

Post a Comment