arc90 lab | tools: Link Thumbnail
Excel Help Forum
ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 10-04-2005, 12:26 PM
fmilano fmilano is offline
Registered User
 
Join Date: 04 Oct 2005
Posts: 1
fmilano is an unknown quantity at this point
Grouping measures

hi,

I'm measuring a feature of some products. I'm taking groups of measures for accuracy. I've got something like this:

Products | Operations | Response Value
Product1 | 10 | 1
Product1 | 5 | 9
Product2 | 10 | 12
Product2 | 5 | 3
Product3 | 10 | 8
Product3 | 5 | 6

I want to show this in a chart, but I don't want Product1 to appear more than once. I would need some way to show Product1 and then as a subtitle or something like that (not as a series), Operations. In other words, I would need to combine Products and Operations as a unique cathegory.

I would really appreciate your answer,

Thanks,

Federico
Reply With Quote
  #2  
Old 10-04-2005, 02:05 PM
MrShorty MrShorty is offline
Forum Guru
 
Join Date: 13 Apr 2005
Posts: 877
MrShorty is an unknown quantity at this point
Not sure what kind of chart you want (bar, line, XY). I created a column chart from your data where I made the category values 10 and 5, the Y values were the response value, and used three different series: one for Product 1, one for product 2, and one for product 3. This gives me a chart where, for each category, I have three columns, each column representing the response value for each product at that number of operations.
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 05:37 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0