How to set up pivot to show name of series item in bar chart
 

I have data on 30 issues. Each issue has multiple characteristics, e.g.,
magnitude, frequency, cost-to-fix, root cause, etc. I want the issues stacked
in a bar chart to depict:
1) Issues by magnitude -with an ID for each issue ( I can get the hover to
show the ID/name and other data. I want only the ID/name and want it fixed in
the chart, not on hover only. I tried TM's hover macro, and though I had
trouble installing it, it doesn't seeem to give me what I want. )
2) Issues by magnitue by frequency - same story, I want to see the issue no.
in the printed bar chart.
Any advice would be greatly appreciated.
Thanks,

--
Lin, PMP, NJ