| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a chart of text data
How can you make a chart using Names in Column A and Places in Column B that
shows how many of the names are from say 7 particular places. Ex: A B Don Boston Jude New York Laura Atlanta Thanks in advance for any help you can lend. S |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a chart of text data
Shellteach -
You could use seven COUNTIF worksheet functions or a Pivot Table to get the counts. And you could use a Bar or Column chart type to display the results. - Mike http://www.MikeMiddleton.com "Shellteach" wrote in message ... How can you make a chart using Names in Column A and Places in Column B that shows how many of the names are from say 7 particular places. Ex: A B Don Boston Jude New York Laura Atlanta Thanks in advance for any help you can lend. S |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a chart of text data
In other words, make a histogram:
http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike Middleton" wrote in message ... Shellteach - You could use seven COUNTIF worksheet functions or a Pivot Table to get the counts. And you could use a Bar or Column chart type to display the results. - Mike http://www.MikeMiddleton.com "Shellteach" wrote in message ... How can you make a chart using Names in Column A and Places in Column B that shows how many of the names are from say 7 particular places. Ex: A B Don Boston Jude New York Laura Atlanta Thanks in advance for any help you can lend. S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating data for a chart | Charts and Charting in Excel | |||
| Creating a chart with text not numbers | Charts and Charting in Excel | |||
| Creating Chart from Two Rows of Data | Excel Discussion (Misc queries) | |||
| Hiding source cell data after creating chart | Charts and Charting in Excel | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Linear Mode
