Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Graph Text values
I have a spreadsheet which contains a drop down box that has different lead
sources (Phone Book, Internet, Postcard Mailer, etc) The x-axis should have the lead source type (found in [table column 1]), and the y-axis should have the number of times that lead source was found in [table column 1] Any help would be greatly appreciated. Thanks, Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart Graph Text values
I don't know how the dropdown relates to your data. In general you need some
kind of list, with the source type in the first column and the count in the second. If what you have is just a long list of lead source types that you need to compile, you could follow one of the approaches on this page: http://peltiertech.com/Excel/ChartsH...idateData.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Eric" wrote in message ... I have a spreadsheet which contains a drop down box that has different lead sources (Phone Book, Internet, Postcard Mailer, etc) The x-axis should have the lead source type (found in [table column 1]), and the y-axis should have the number of times that lead source was found in [table column 1] Any help would be greatly appreciated. Thanks, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excluding empty/zero values in graph - highlight area in chart | Excel Discussion (Misc queries) | |||
formatting text on chart for specific values | Charts and Charting in Excel | |||
Need help with chart graph not on chart wizard | Charts and Charting in Excel | |||
Values for Graph | Excel Discussion (Misc queries) | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel |