Fat bar in Bar Chart

I have a percent stacked bar chart. For a number of entries it shows nice,
however, if there is only one entry, the one bar fills the whole chart,
obscuring any major/minor grid lines as well.
Is there a way to specify something so that the width of the one single bar
is more respectable?
Thanks.Yes there is a way to control the width of columns and bars. The property is
called "PointWidth". However, the property is only supported on the report
server (and preview).
What you need to do is:
* open your RDL file in a text / xml-editor
* search for the chart (<chart name="...">)
* add a PointWidth value between 0 and 100 (by default it is 55)
Example:
<Chart Name="Sales">
<PointWidth>10</PointWidth>
...
</Chart>
See also:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
Note: PointWidth is a constant value, so if you have an unknown number of
categories at runtime you might want to use two identical charts (one with
regular PointWidth, the other with a small PointWidth) and based on a
condition (number of categories) always hide one chart.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:%23mT$8gsZEHA.3476@.tk2msftngp13.phx.gbl...
> I have a percent stacked bar chart. For a number of entries it shows nice,
> however, if there is only one entry, the one bar fills the whole chart,
> obscuring any major/minor grid lines as well.
> Is there a way to specify something so that the width of the one single
bar
> is more respectable?
> Thanks.
>|||Hi Robert, thanks for the answer.
I found that the PointWidth has an affect if there are two or more bars, but
it has no affect for one bar, as one bar still fills the whole chart. I like
the charting features, especially after SP1, just this looks sort of tacky.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:eG99i3sZEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Yes there is a way to control the width of columns and bars. The property
is
> called "PointWidth". However, the property is only supported on the report
> server (and preview).
> What you need to do is:
> * open your RDL file in a text / xml-editor
> * search for the chart (<chart name="...">)
> * add a PointWidth value between 0 and 100 (by default it is 55)
> Example:
> <Chart Name="Sales">
> <PointWidth>10</PointWidth>
> ...
> </Chart>
> See also:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
> Note: PointWidth is a constant value, so if you have an unknown number of
> categories at runtime you might want to use two identical charts (one with
> regular PointWidth, the other with a small PointWidth) and based on a
> condition (number of categories) always hide one chart.
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:%23mT$8gsZEHA.3476@.tk2msftngp13.phx.gbl...
> > I have a percent stacked bar chart. For a number of entries it shows
nice,
> > however, if there is only one entry, the one bar fills the whole chart,
> > obscuring any major/minor grid lines as well.
> > Is there a way to specify something so that the width of the one single
> bar
> > is more respectable?
> >
> > Thanks.
> >
> >
>|||You should turn on "side margins" for the x-axis.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:eLqMvZuZEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Hi Robert, thanks for the answer.
> I found that the PointWidth has an affect if there are two or more bars,
but
> it has no affect for one bar, as one bar still fills the whole chart. I
like
> the charting features, especially after SP1, just this looks sort of
tacky.
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:eG99i3sZEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > Yes there is a way to control the width of columns and bars. The
property
> is
> > called "PointWidth". However, the property is only supported on the
report
> > server (and preview).
> >
> > What you need to do is:
> > * open your RDL file in a text / xml-editor
> > * search for the chart (<chart name="...">)
> > * add a PointWidth value between 0 and 100 (by default it is 55)
> >
> > Example:
> > <Chart Name="Sales">
> > <PointWidth>10</PointWidth>
> > ...
> > </Chart>
> >
> > See also:
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
> >
> > Note: PointWidth is a constant value, so if you have an unknown number
of
> > categories at runtime you might want to use two identical charts (one
with
> > regular PointWidth, the other with a small PointWidth) and based on a
> > condition (number of categories) always hide one chart.
> >
> > --
> > Robert M. Bruckner
> > Microsoft SQL Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> > news:%23mT$8gsZEHA.3476@.tk2msftngp13.phx.gbl...
> > > I have a percent stacked bar chart. For a number of entries it shows
> nice,
> > > however, if there is only one entry, the one bar fills the whole
chart,
> > > obscuring any major/minor grid lines as well.
> > > Is there a way to specify something so that the width of the one
single
> > bar
> > > is more respectable?
> > >
> > > Thanks.
> > >
> > >
> >
> >
>|||Right, thanks, that does it.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:#nIuy2uZEHA.3012@.tk2msftngp13.phx.gbl...
> You should turn on "side margins" for the x-axis.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:eLqMvZuZEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Hi Robert, thanks for the answer.
> > I found that the PointWidth has an affect if there are two or more bars,
> but
> > it has no affect for one bar, as one bar still fills the whole chart. I
> like
> > the charting features, especially after SP1, just this looks sort of
> tacky.
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:eG99i3sZEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > > Yes there is a way to control the width of columns and bars. The
> property
> > is
> > > called "PointWidth". However, the property is only supported on the
> report
> > > server (and preview).
> > >
> > > What you need to do is:
> > > * open your RDL file in a text / xml-editor
> > > * search for the chart (<chart name="...">)
> > > * add a PointWidth value between 0 and 100 (by default it is 55)
> > >
> > > Example:
> > > <Chart Name="Sales">
> > > <PointWidth>10</PointWidth>
> > > ...
> > > </Chart>
> > >
> > > See also:
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsrdl/htm/rsp_ref_rdl_elements_fp_87lg.asp
> > >
> > > Note: PointWidth is a constant value, so if you have an unknown number
> of
> > > categories at runtime you might want to use two identical charts (one
> with
> > > regular PointWidth, the other with a small PointWidth) and based on a
> > > condition (number of categories) always hide one chart.
> > >
> > > --
> > > Robert M. Bruckner
> > > Microsoft SQL Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> > > news:%23mT$8gsZEHA.3476@.tk2msftngp13.phx.gbl...
> > > > I have a percent stacked bar chart. For a number of entries it shows
> > nice,
> > > > however, if there is only one entry, the one bar fills the whole
> chart,
> > > > obscuring any major/minor grid lines as well.
> > > > Is there a way to specify something so that the width of the one
> single
> > > bar
> > > > is more respectable?
> > > >
> > > > Thanks.
> > > >
> > > >
> > >
> > >
> >
> >
>