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
|
|||
|
|||
Pie chart problem
I have a spreadsheet, transferred from access database of previous children's
party bookings. This s/sheet contains many columns containing info as below. Title, First Name, Last Name, Address, City, County, Postcode, Home Phone, Mobile Phone, Email Address, Date, Child's name, Age, Gender, Party Theme, Duration, Enquiry Source. For the purposes of business analysis/future marketing/advertising I am trying to create pie charts to analyse by %. For example I wish to create a pie chart of the column titled Enquiry source which contains customer responses as categorised below- INTERNET- YELL.COM FLYER INTERNET- KINGSTON ONLINE INTERNET- GOOGLE YELLOW PAGES INTERNET- NOT SPEC FAMILIES MAG INTERNET- UK ENTS UNKNOWN WORD OF MOUTH etc etc How do i create a chart with multiple categories/data as above from one column. to date all that happens is the first title in column just shows up as a single line!!! Please help |
#2
|
|||
|
|||
Pie chart problem
Hi,
I think this may be what you are looking for: Suppose you want to plot the data in the Enquiry Source column, lets say that is column K. Make a list of the unique entries from column K, here in cell N1:N5 and in cell O1 enter the formula =COUNTIF(K$1:K$100,N1) copy this formula down beside each entry in column N and then plot columns N and O as a pie. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SURGEON1971" wrote: I have a spreadsheet, transferred from access database of previous children's party bookings. This s/sheet contains many columns containing info as below. Title, First Name, Last Name, Address, City, County, Postcode, Home Phone, Mobile Phone, Email Address, Date, Child's name, Age, Gender, Party Theme, Duration, Enquiry Source. For the purposes of business analysis/future marketing/advertising I am trying to create pie charts to analyse by %. For example I wish to create a pie chart of the column titled Enquiry source which contains customer responses as categorised below- INTERNET- YELL.COM FLYER INTERNET- KINGSTON ONLINE INTERNET- GOOGLE YELLOW PAGES INTERNET- NOT SPEC FAMILIES MAG INTERNET- UK ENTS UNKNOWN WORD OF MOUTH etc etc How do i create a chart with multiple categories/data as above from one column. to date all that happens is the first title in column just shows up as a single line!!! Please help |
#3
|
|||
|
|||
Pie chart problem
Hi Shane,
I tried your suggested formula. I am a complete novice with excel. Presumably i needed to replace your specified column letter with the actual column letter which is R? I then followed the rest of your instructions but still the pie chart shows a single line, although now the titles of each customer response are showing up with a colour code. Please advise further. "Shane Devenshire" wrote: Hi, I think this may be what you are looking for: Suppose you want to plot the data in the Enquiry Source column, lets say that is column K. Make a list of the unique entries from column K, here in cell N1:N5 and in cell O1 enter the formula =COUNTIF(K$1:K$100,N1) copy this formula down beside each entry in column N and then plot columns N and O as a pie. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SURGEON1971" wrote: I have a spreadsheet, transferred from access database of previous children's party bookings. This s/sheet contains many columns containing info as below. Title, First Name, Last Name, Address, City, County, Postcode, Home Phone, Mobile Phone, Email Address, Date, Child's name, Age, Gender, Party Theme, Duration, Enquiry Source. For the purposes of business analysis/future marketing/advertising I am trying to create pie charts to analyse by %. For example I wish to create a pie chart of the column titled Enquiry source which contains customer responses as categorised below- INTERNET- YELL.COM FLYER INTERNET- KINGSTON ONLINE INTERNET- GOOGLE YELLOW PAGES INTERNET- NOT SPEC FAMILIES MAG INTERNET- UK ENTS UNKNOWN WORD OF MOUTH etc etc How do i create a chart with multiple categories/data as above from one column. to date all that happens is the first title in column just shows up as a single line!!! Please help |
Thread Tools | |
Display Modes | |
|
|