 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / May 2008Using less than and greater than in charts
Hi, I would like to be able to create a chart with data which has a less than, greater than format (i.e. >10%<20%) as I don't have the actual percentages. I need the chart to be clustered as I want to be able to plot monthly directions (N, S, E, W). Thank you in advance Jane Hi, Charts will only plot true numbers. >10% will be treated as text and as such plotted as zero. I guess you could change the >10% to 10% and add some notation to highlight the fact that it is not a true value. Cheers Andy > Hi, I would like to be able to create a chart with data which has a less > than, greater than format (i.e. >10%<20%) as I don't have the actual [quoted text clipped - 3 lines] > Thank you in advance > Jane  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.