Charting problem

Hi all. I have plotted a chart based on the data obtained. However, is there a way to limit the number of bars to be displayed in the chart?
Lets say, I have data from Jan to Dec, i needed all the data because i need the accumulated figures from each month.
But, I do not wish to display in the bar chart for data from Jan to Dec.
There are section in the detail for hiding some data, but I dont know about chart.
Any comments are appreciated!Well, give us an example - what period do you wish to chart on, if it's not Jan-Dec??|||Lets say the data needed is from Jan to Dec, because I need to calculate the running total for the accumulated figures for other processing purposes.
Then for the chart, I would like to plot the data from Sept to Dec only. Is it possible?
The date field is used as a criteria for grouping.

Chart Question: Number of Bars on X-axis

Hi Guys,
Is there any way, we can set the number of Bars on X-axis per Page (in a
Column Chart) in Report Designer?
All I want to do is set no of Bars per page so that a new page is created if
the number of bars on the X-axis exceeds the given value..
Any help is appreciated..
Regards
Raj ChidipudiThis is not natively supported in RS2000.
Depending on your actual data, you may be able to use filters on the first
chart and dynamically show/hide additional charts (with page breaks) if the
number of bars is too high for the first chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj Chidipudi" <someone@.email.com> wrote in message
news:Ok9QsdbmEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi Guys,
> Is there any way, we can set the number of Bars on X-axis per Page (in a
> Column Chart) in Report Designer?
> All I want to do is set no of Bars per page so that a new page is created
if
> the number of bars on the X-axis exceeds the given value..
> Any help is appreciated..
> Regards
> Raj Chidipudi
>

Chart legend has too much data - how to only show 1 legend

I have created a hybrid bar chart / with line. Basically uses the bars to
show sales for each geographic region. A single line is plotted showing the
sales goal to be reached. The x axis is "Region" The y axis value 1 is total
sales $. I added y value 2 to show the sales goal $ and the legend
automatically got populated with series labels. I only want the x axis
labels to be in the legend.
How can I fix this?NP,
This is not a direct answer to your question, but I got tired of the report
legend and what seemed the lack of configuration and used a nice trick from
the Technical Article: Get More Out of SQL Server Reporting Services Charts
(http://msdn2.microsoft.com/en-us/library/aa964128.aspx) to create my own
legend. The document is excellent, five stars.
If you use the Custom Chart Color Palettes and Legends section from the doc
you will see what I mean. You are able to create your own legend and use what
you want and remove what you don't.
Hope this helps.
Reeves
"NP" wrote:
> I have created a hybrid bar chart / with line. Basically uses the bars to
> show sales for each geographic region. A single line is plotted showing the
> sales goal to be reached. The x axis is "Region" The y axis value 1 is total
> sales $. I added y value 2 to show the sales goal $ and the legend
> automatically got populated with series labels. I only want the x axis
> labels to be in the legend.
> How can I fix this?

CHART COLUMNS

Is there a way to put a border around the bars in the cart. I didnt think
there was, but I hope to be mistaken. ThanksHave you tried:
Chart Properties> Data tab> Values> [select value]> Edit>
Appearence tab> Series style> Border and line tab
HTH,
Magendo_man
"Ben Watts" wrote:
> Is there a way to put a border around the bars in the cart. I didnt think
> there was, but I hope to be mistaken. Thanks
>
>|||Thanks, that works, one more chart question. If I have a pie chart, how do
I get it to show up if there isnt any data?
"magendo_man" <magendoman@.discussions.microsoft.com> wrote in message
news:AB293EDA-47DE-4704-A6F2-DA40B4E652A1@.microsoft.com...
> Have you tried:
> Chart Properties> Data tab> Values> [select value]> Edit>
> Appearence tab> Series style> Border and line tab
> HTH,
> Magendo_man
> "Ben Watts" wrote:
>> Is there a way to put a border around the bars in the cart. I didnt
>> think
>> there was, but I hope to be mistaken. Thanks
>>