|
|
|
||||||||||||
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
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.
|
![]() |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|