#1   Report Post  
fmilano
 
Posts: n/a
Default 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


--
fmilano
------------------------------------------------------------------------
fmilano's Profile: http://www.excelforum.com/member.php...o&userid=27795
View this thread: http://www.excelforum.com/showthread...hreadid=473025

  #2   Report Post  
MrShorty
 
Posts: n/a
Default


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.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=473025

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
Grouping stuart.young Excel Discussion (Misc queries) 1 August 1st 05 12:56 PM
Grouping Kevin M Excel Worksheet Functions 1 June 10th 05 11:11 PM
How to unprotect Grouping controls Bob Laithwaite Excel Worksheet Functions 1 May 18th 05 01:32 AM
grouping of cells in protected sheets Christian Galbavy Excel Worksheet Functions 1 May 10th 05 12:32 AM
Date Format Pivot Grouping Easton Excel Discussion (Misc queries) 1 March 8th 05 12:53 PM


All times are GMT +1. The time now is 04:53 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"