Charting data values with special characters
I am working on Excel 2003 and I am having issues showing data with special characters on a line chart. Some data is as follows: <0.005, <0.1, <0.025. I need my data table to show these actual values and for the values to appear on my line chart.
I know the data on the chart will display without the special characters, which is fine.
make a helpcolumn in which you delete the soecial character.
after that use that helpcolumn for making the chart.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I am not looking for the column value to be returned. I attached an example data sheet. I need to graph that without changing the data values or removing the special character.
With the metod in #2.
See the attached file.
My suggestion is to use anyway extra column with < sign removed to have real numbers in this column to be plotted.
but !!!
use custom formatting like:
to have it displayed with the sign. (the same as it looked like while they were texts not numbers)
Please Login or Register to view this content.
Now you can plot line graph with data table
probably you will also have to format numbers on vertical axis as General (excel will use by default the same custom formatting as used by data.
See attached file
As your decimal part separator is dot not comma, you can use shorter version of formula:
Formula:
Please Login or Register to view this content.
Bez nazwy.jpg
Last edited by Kaper; 03-09-2015 at 04:11 AM.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks