Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a Chart from character data?
Need to create a chart from character data. Do I use pivot table or bar/pie
chart and do I need to create a Macro? Basically, how do I do this? |
#2
|
|||
|
|||
Is this a column of text, and you want a chart to show the frequency of
each item in the list? If so, add a heading to the column, then create a pivot table to summarize the data, and create a pie chart from the pivot table results. In your pivot table, add the text field button to the row area, and another copy of the same field button to the data area, where it will become 'Count of text'. There are instructions for pivot tables in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Ddemby wrote: Need to create a chart from character data. Do I use pivot table or bar/pie chart and do I need to create a Macro? Basically, how do I do this? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Pie Chart from a LIST of Data? | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |