Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding text in a chart
I am have a spread sheet with people's names and and an id number in
the same cell. I want to create a chart to compare these people but I need to have only their id number show up and not their name on the chart. Is there any way to do this???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding text in a chart
One way of doing it would be extracting the ID from the mixed cell to other
column (the logic will depend in each case, normally with LEFT, MID and RIGHT functions), and create the graph using that new column as the source. Hope this helps, Miguel. "japc90" wrote: I am have a spread sheet with people's names and and an id number in the same cell. I want to create a chart to compare these people but I need to have only their id number show up and not their name on the chart. Is there any way to do this???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding text in a chart
Thank you for the suggestion
Miguel Zapico wrote: One way of doing it would be extracting the ID from the mixed cell to other column (the logic will depend in each case, normally with LEFT, MID and RIGHT functions), and create the graph using that new column as the source. Hope this helps, Miguel. "japc90" wrote: I am have a spread sheet with people's names and and an id number in the same cell. I want to create a chart to compare these people but I need to have only their id number show up and not their name on the chart. Is there any way to do this???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis title text box is wrong size in chart for excel 2003 | Charts and Charting in Excel | |||
how to change line spacing for text box in excel chart | Charts and Charting in Excel | |||
Dynamic Text in a Chart | Excel Discussion (Misc queries) | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
Hiding or Displaying Series In a Chart | Charts and Charting in Excel |