Can I make an Excel chart from only one column?
October 20, 2008 3:06 PM Subscribe
How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column?
posted by niles to Computers & Internet (7 answers total) 4 users marked this as a favorite
This seems like it should be really simple, but I can't for the life of me figure this out.
I have an excel spreadsheet with about 150 rows of marketing data that I'd like be able to chart, but with only a single column of data per chart. Maybe this is possible with Pivot Tables? I can't figure that out.
Here's an example: Column H has the cities everyone lives in. I want a chart showing how many people live in a given city. I could obviously count this out by hand ("Ok, that's 5 for San Diego.."), but I can't help but think Excel should be able to do the heavy lifting for me. I'm fine using macros/VBA, but this seems so simple! Famous last words, I know.
Let me know if I need to clarify this.