1. Percentages in Table with Excel : My excel has a column of data in percentages e.g. 2.3%. When I import the excel, the column shows 0.023. It seems I have to set my excel column to show 2.3 and then add % as text after in setting up the table. Is that correct? Or is there a better way to bring excel percentage column?
2. When I use highcharts, the labeling removes the percentages and shows the table data as decimal numbers. So the (e.g bar) chart will show .023 as the value and not 2.3%. Is there way to format chart data as well? Or how do we get chart to show data in percentages? Not sure if I saw this in documentation. If it is there, please send me the link to that section of the documentation. tks
1. My suggestion will be to enter the data in this format in Excel 2.3 and set that column type to float. Define the decimal places in wpdatatables settings ( for example 1 decimal places) and then use display text after for that float column where you can enter that % sign.
2. Can you please send me the link where you have that chart so I can take a look and give you my suggestion.
Great Plugin...learning to use it now!!!
1. Percentages in Table with Excel : My excel has a column of data in percentages e.g. 2.3%. When I import the excel, the column shows 0.023. It seems I have to set my excel column to show 2.3 and then add % as text after in setting up the table. Is that correct? Or is there a better way to bring excel percentage column?
2. When I use highcharts, the labeling removes the percentages and shows the table data as decimal numbers. So the (e.g bar) chart will show .023 as the value and not 2.3%. Is there way to format chart data as well? Or how do we get chart to show data in percentages? Not sure if I saw this in documentation. If it is there, please send me the link to that section of the documentation. tks
regards,
Hi metamindz,
Thank you for your purchase.
1.
My suggestion will be to enter the data in this format in Excel 2.3 and set that column type to float.
Define the decimal places in wpdatatables settings ( for example 1 decimal places) and then use display text after for that float column where you can enter that % sign.
2.
Can you please send me the link where you have that chart so I can take a look and give you my suggestion.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you. Issue resolved.