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
|
|||
|
|||
Charting text?
I have a user that has a column with text entries like "Accounting"
"Marketing" etc. He wants a column graph where the more "Accounting" appears in the data column, the taller the chart column. Does anyone have any ideas how to do this? I'm thinking a "Count" function, but there are a number of data definitions. Perhaps someone knows of a macro that would count the various unique entries and use them as the column titles in the chart? THANKS |
#2
|
|||
|
|||
Charting text?
Jim -
Put a header on this column of data. Select the column of text labels, and using the Data menu, create a pivot table. When you get the empty pivot table frame, drag the column header from the pivot table field list (floating by the pivot table) to the Rows area, then drag it again (i.e., another copy of it) to the Data area. You'll get a list of unique labels and a count of their appearance in the column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "Jim at SDSU" wrote in message ... I have a user that has a column with text entries like "Accounting" "Marketing" etc. He wants a column graph where the more "Accounting" appears in the data column, the taller the chart column. Does anyone have any ideas how to do this? I'm thinking a "Count" function, but there are a number of data definitions. Perhaps someone knows of a macro that would count the various unique entries and use them as the column titles in the chart? THANKS |
#3
|
|||
|
|||
Charting text?
I think this is like my problem, how do you add a separate header to a column though? I'm dumb, I know. -- silentop ------------------------------------------------------------------------ silentop's Profile: http://www.excelforum.com/member.php...o&userid=32271 View this thread: http://www.excelforum.com/showthread...hreadid=519940 |
#4
|
|||
|
|||
Charting text?
You type it into the row above the top cell of the data. You might have to
insert a blank row first. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "silentop" wrote in message ... I think this is like my problem, how do you add a separate header to a column though? I'm dumb, I know. -- silentop |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |