| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using 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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Using less than and greater than in charts
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 Jane wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
| if value is greater than # * by 20% if less * by 40 | New Users to Excel | |||
| Greater Than but Less than | Excel Worksheet Functions | |||
| greater control of date/time stamps on line charts in excel | Charts and Charting in Excel | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Linear Mode
