Using less than and greater than in charts

J

Jane

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater than, less than, AS WELL AS value=0 5
Pie Chart 2
Data points in chart incorrect 0
How do I set up a chart to only chart values greater than 0 2
Display data points that are less than the chart trendline 2
Aggregating Data in Other Category on Pie Chart 2
Employee Schedule not plotting properly - chart type / data series not correct 0
How do I get source data to show on a chart only if greater than z 4

Top