If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
rename category names
I have the data in the below format
vendor amount a 100 b 200 c 300 d 400 Now in the chart i want the category names as a,b,other(c,d should appear as other). Total amount of c and d should show up for other. Can you please suggest how this is possible. |
#2
|
|||
|
|||
rename category names
Hi,
The chart will not summarise or group your data. You do that on the worksheet using formula then plot the new summarised data. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rename category names" rename category wrote in message ... I have the data in the below format vendor amount a 100 b 200 c 300 d 400 Now in the chart i want the category names as a,b,other(c,d should appear as other). Total amount of c and d should show up for other. Can you please suggest how this is possible. |
#3
|
|||
|
|||
rename category names
The data for my pivot chart comes from pivot table. I was able to group the
data using the group option but the problem is it puts c,d in one group and a,b in another group. So in the chart i see both these groups. Is there a way i can group only c,d so when i look in the chart the category names appear as a,b,other. "Andy Pope" wrote: Hi, The chart will not summarise or group your data. You do that on the worksheet using formula then plot the new summarised data. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rename category names" rename category wrote in message ... I have the data in the below format vendor amount a 100 b 200 c 300 d 400 Now in the chart i want the category names as a,b,other(c,d should appear as other). Total amount of c and d should show up for other. Can you please suggest how this is possible. . |
#4
|
|||
|
|||
rename category names
I was able to resolve the issue.
Thanks a lot. "rename category names" wrote: The data for my pivot chart comes from pivot table. I was able to group the data using the group option but the problem is it puts c,d in one group and a,b in another group. So in the chart i see both these groups. Is there a way i can group only c,d so when i look in the chart the category names appear as a,b,other. "Andy Pope" wrote: Hi, The chart will not summarise or group your data. You do that on the worksheet using formula then plot the new summarised data. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "rename category names" rename category wrote in message ... I have the data in the below format vendor amount a 100 b 200 c 300 d 400 Now in the chart i want the category names as a,b,other(c,d should appear as other). Total amount of c and d should show up for other. Can you please suggest how this is possible. . |
Thread Tools | |
Display Modes | |
|
|