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 Gridline Question

Is there a way to make Y axis gridlines intervals change dynamically?
Basically increase/decrease base on numbers being graph.Not in rs2k don't know about rs2k5. I got round this by overlaying graphs
and hiding the ones i didn't want to see depending on how much data i got
out.
Greg
"Johnny C" <JohnnyC@.discussions.microsoft.com> wrote in message
news:DD600FE2-F167-4B8E-8126-693E57B31D0B@.microsoft.com...
> Is there a way to make Y axis gridlines intervals change dynamically?
> Basically increase/decrease base on numbers being graph.

Chart Drill Through Bug?

I have a peculiar problem with a line chart that has a "jump to report"
action. The chart basically shows sales by month, with two different
lines for 2004 and 2005. When a user clicks on a specific month, it
jumps to a detailed report for that month. This works beautifully
except for one problem:
The first month is the starting point of the line graph, call it
December. Clicking on the line anywhere between December and January
jumps to the January detail report. In a way, I guess this sort of
makes sense because otherwise I guess you wouldn't be able to drill to
the last month on the graph. What I'd really like to be able to is not
make the "line" interactive at all. I'd rather define the drill
through in the point label itself. So that when you click on the point
label for December, then you go to the december report.
Does anyone know of way to do that? Maybe by directly defining it in
the rdl?Did you look into using datapoint "markers"? They can help to improve line
charts to make the drillthrough links more obvious (especially if the
markers are bigger than the line width).
The described behavior (the line is also interactive) is inherent to design
of the chart control and cannot be changed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jordo" <jordan_mccall@.hotmail.com> wrote in message
news:1107300323.493686.4760@.z14g2000cwz.googlegroups.com...
> I have a peculiar problem with a line chart that has a "jump to report"
> action. The chart basically shows sales by month, with two different
> lines for 2004 and 2005. When a user clicks on a specific month, it
> jumps to a detailed report for that month. This works beautifully
> except for one problem:
> The first month is the starting point of the line graph, call it
> December. Clicking on the line anywhere between December and January
> jumps to the January detail report. In a way, I guess this sort of
> makes sense because otherwise I guess you wouldn't be able to drill to
> the last month on the graph. What I'd really like to be able to is not
> make the "line" interactive at all. I'd rather define the drill
> through in the point label itself. So that when you click on the point
> label for December, then you go to the december report.
> Does anyone know of way to do that? Maybe by directly defining it in
> the rdl?
>|||Brilliant! This works quite well. Thank you for your help!