Bars on Bar chart

Is there a way to set the width of each bar on a barchart? Currently the
bars run into the next bar on the graph. I want to be able to leave a blank
space between bars. Can this be done?
Thanks,
PhillThere 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 designer preview).
What you need to do is:
* open your RDL file in a text / xml-editor or in "code view" of designer
* search for the chart (<chart name="...">)
* add a PointWidth value between 0 and 100 (by default it is 55)
Example:
<Chart Name="Sales">
<PointWidth>30</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
This posting is provided "AS IS" with no warranties, and confers no rights.
"smogerp" <smogerp@.discussions.microsoft.com> wrote in message
news:F57A3443-3F65-425C-A4E5-5A7E2004F921@.microsoft.com...
> Is there a way to set the width of each bar on a barchart? Currently the
> bars run into the next bar on the graph. I want to be able to leave a
> blank
> space between bars. Can this be done?
> Thanks,
> Phillsql

Bar Graph's Y Axis as 10k, 20k, 30k

Hi,
The Y-axis value on my Bar Graph displays as 10000, 20000, 30000 . . not good aesthetics and not legible when figure goes beyond 6 in size
I need to show it as 10k, 20k, 30k, like Crystal Reports does by default...
How can i do this ?
ThanksRight-click on the chart to open the chart properties dialog. Go to the
Y-axis tab, and use the following formatcode:
0,k
This will give you 10k, 20k, etc. Further information is available on MSDN:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"push" <push@.discussions.microsoft.com> wrote in message
news:D6FF9A5C-8350-434D-A80D-7977F35D5614@.microsoft.com...
> Hi,
> The Y-axis value on my Bar Graph displays as 10000, 20000, 30000 . . not
good aesthetics and not legible when figure goes beyond 6 in size
> I need to show it as 10k, 20k, 30k, like Crystal Reports does by
default...
> How can i do this ?
> Thanks

Bar Graphs border

If you add a bar graph chart and set a black border for the bars, it does not work. As soon as you change it to anything but black, like #000001 it works. Is this a bug that has been fixed in the new version.

Another thing that would greatly enhance the reports is the ability to compare line graphs, ie to have 2 y-axis. Has this been added in the new 2005 version or is this up to Dundas?

Also, the preview in VS 2003 has issues. If the report has parameters and you click on the page it refreshes the report and sometime a GDI+ error comes up and you have to close and open the report. It gets irritating after while, especially with long complex reports. The preview also doesnt format like it would when its printed out in pdf, some things wont align for instance (This is after the print preview button is pressed).

Regarding "black" border: this is a known issue in report designer. It does not serialize color values if they are set to "black" (since it is the RDL default color). As you have already identified, you could use #000001, or you could use an expression ="Black".

Regarding "dual y-axis": Sorry, this did not make it into the SQL Server 2005 release.

-- Robert

Bar charts

I have created a bar graph but cannot find a way to change the bar's color for different series.

I have a graph which has sales men and their sales between dates

Thanks for your help

Hi there,

There are lots of postings for this. Can you try this one?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=222204&SiteID=1

cheers,

Andrew

|||Have you set up a series group?|||

No I hadn't

Thanks for your help

|||

The only problem Im getting with setting it up as a series group is the chart lines are now the size of a match.

Is it possible to fatten them up?

sql

bar and line graph on same chart ?

Hi
Is it possible to have bar and line graphs on the same chart in Crystal?
I know this can be done in Excel fairly easily...bump.....

Bar and line chart on same graph

Hi,
Is it possible to have a Bar chart and a Line chart on the same graph? I
have a series that I would like to display as a Bar chart and anther series
as line chart. is it possible?
thanks,In the Report Designer, go to the Chart Properties dialog. Click on the Data
tab, select the data point you want to make a line, click 'Edit..'. In the
chart value dialog, click on the Appearance tab and select 'Plot Data as
Line'.
"Prash" wrote:
> Hi,
> Is it possible to have a Bar chart and a Line chart on the same graph? I
> have a series that I would like to display as a Bar chart and anther series
> as line chart. is it possible?
> thanks,