Bar Chart Legend with Data set names and values 2

[gonetkeygo]

I am using CR10 and want to display a bar chart with a legend that includes the values for each of the bar.

For example, if the data set was foo=1, bar=10, baz=100, then i would like the legend to include both foo and 1, etc....

Am i missing something really simple (i feel like i am)? Or it this impossible (i hope not)?

Thanks,

Joe

 

[rosemaryl]

Dear Joe,

It does seem odd that Crystal only provides this for Pie charts and not for Bar Charts. However, that is the case.

If you have a simple bar chart that could also be a pie chart what I do is to create the pie chart with the legend showing the BOTH in the Chart Expert Options Tab.

I size the chart with the pie from edge to edge. I make the pie itself very small.

Now, I create a bar chart and place it ON TOP of the pie chart but have sized it so that the PIE legend shows on the right side of the bar. The bar chart is set to not display a legend. In other words the total width of the bar chart is less than the width of the pie chart so that the legend from the pie shows.

While it seems stupid to have to do it this way ... it does work.

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[gonetkeygo]

that's a creative way of solving the problem!!!

thanks,

joe

 

[smcnulty2000]

I love this solution, Rosemary.

scottm.