Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL WITH TEXT ONLY
I want to create a chart, the excel worksheet is only populated with text
fields, but there are eg: SDP ABSDPA ABSDPB ABSDPC Node ABMSC1 ABSCP1 ABSCP1 ABSCP1 ABMSC2 ABSCP1 ABSCP1 ABSCP1 ABMSC3 ABSCP1 ABSCP1 ABSCP1 ABMSC4 ABSCP3 ABSCP3 ABSCP3 ABMSC5 ABSCP3 ABSCP3 ABSCP3 how do i display this in a chart? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL WITH TEXT ONLY
Ask yourself how you would do this manually.
How would you know were to place each data point? Charting works only with numeric y-values best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Diloo" wrote in message ... I want to create a chart, the excel worksheet is only populated with text fields, but there are eg: SDP ABSDPA ABSDPB ABSDPC Node ABMSC1 ABSCP1 ABSCP1 ABSCP1 ABMSC2 ABSCP1 ABSCP1 ABSCP1 ABMSC3 ABSCP1 ABSCP1 ABSCP1 ABMSC4 ABSCP3 ABSCP3 ABSCP3 ABMSC5 ABSCP3 ABSCP3 ABSCP3 how do i display this in a chart? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL WITH TEXT ONLY
Charts are for displaying numerical values. You don't have any, so you
can't plot them. If you want to use your spreadsheet to derive some appropriate numerical values (such as counts), then those values can be plotted. What sort of chart did you have in mind? What do you want it to show? -- David Biddulph "Diloo" wrote in message ... I want to create a chart, the excel worksheet is only populated with text fields, but there are eg: SDP ABSDPA ABSDPB ABSDPC Node ABMSC1 ABSCP1 ABSCP1 ABSCP1 ABMSC2 ABSCP1 ABSCP1 ABSCP1 ABMSC3 ABSCP1 ABSCP1 ABSCP1 ABMSC4 ABSCP3 ABSCP3 ABSCP3 ABMSC5 ABSCP3 ABSCP3 ABSCP3 how do i display this in a chart? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
HOW TO CHANGE BAHTTEXT (THAI TEXT) TO ENGLISH TEXT IN EXCEL | Excel Worksheet Functions |