I want to use a column chart with legand showing in the chart
I have a query
select sum(quantity) as Quantity,Category, organization from temp1 group by category,organization
I have the data showing correctly but the format of chart is not correct. I have each category showing by organization however the spacing between the series is not there and the x axis legend should say the category and legend on the top should say the organization. I have the x-axis and legend both showing the same data.
I'm not exactly sure what you're trying to describe. Can you attach an image?
Regarding the legend, are you referring to the top and bottom chart titles? These are text strings that you have to set directly, for example: chart.TitleBottom.Text = "bottom text"; chart.TitleTop.Text = "top text";
Never mind I figured it out.