Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create interactive pivot table chart based on item selected Sacto Harley Charts and Charting in Excel 0 October 10th 07 10:50 PM
Multiple chart series for Pivot Chart MJW[_2_] Charts and Charting in Excel 0 August 15th 07 08:16 PM
Pivot Chart - multiple Data series Andy Charts and Charting in Excel 4 January 5th 07 05:39 PM
Pivot Chart - X,Y & Data Series Options Graham Haslehurst Charts and Charting in Excel 4 November 24th 05 02:51 PM
Can I have each series be a different field in a Pivot Chart? tyson12 Charts and Charting in Excel 1 June 30th 05 09:33 PM


All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"