Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying symbols in charts with tables
I am trying to create a chart of percentages with the data table displayed
with the dhart in Excel 2003. The problem is that I have some symbols in the table (e.g., <1%), which when charted are treated as text and simply show up as a zero in the data table. I would appreciate any suggestions for getting these symbols to appear correctly in the data table displayed with the chart. Thanks! -Aaron |
#2
|
|||
|
|||
jageorge,
Unfortunately, you have very little control over the data tables that appear as an option. You can get around this limitation by using worksheet cells as a data table. This example of how to do so might help: http://pubs.logicalexpressions.com/p...cle.asp?ID=509 Also, you can "shoot a picture" of a worksheet range and use it as a legend. You can refer to this example: http://www.pdbook.com/index.php/exce...s_camera_tool/ ---- Regards, John Mansfield http://www.pdbook.com "jageorge" wrote: I am trying to create a chart of percentages with the data table displayed with the dhart in Excel 2003. The problem is that I have some symbols in the table (e.g., <1%), which when charted are treated as text and simply show up as a zero in the data table. I would appreciate any suggestions for getting these symbols to appear correctly in the data table displayed with the chart. Thanks! -Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
How to paste Xcel tables legibly into Word . Help!! | Excel Discussion (Misc queries) | |||
displaying several charts, one at the time | Charts and Charting in Excel |