How do I format the value to be a currency £ so it reads Fertilizer £14,325.60
On Tuesday, June 15, 2021 at 9:55:39 PM UTC+1 Dean Williams wrote: > [image: chart.jpg] > > On Tuesday, June 15, 2021 at 9:52:50 PM UTC+1 Dean Williams wrote: > >> I have tried and failed >> <TD colspan=2> >> <script type="text/javascript" src=" >> https://www.gstatic.com/charts/loader.js";></script> >> <script type="text/javascript"> >> google.charts.load('current', {'packages':['corechart'], >> 'language': 'en-gb'}); >> google.charts.setOnLoadCallback(drawVisualization); >> >> function drawVisualization() { >> // Some raw data (not necessarily accurate) >> var data = google.visualization.arrayToDataTable([ >> <?php include("Data_06_15_6.php"); ?> >> ]); >> var formatter = new google.visualization.NumberFormat({ >> prefix: '£', >> negativeParens: true >> }); >> var options = { >> title : 'Totals by Paddock for <?php echo $farm_name; ?>', >> titleFontSize:30, >> fontName: 'tahoma', >> fontSize: '16', >> format: "currency", >> prefix:"£", >> width:780, >> height:520, >> vAxis: {title: '', format: '£#,##0.00;(£#,##0.00)', prefix:"£", >> fontSize: '24'}, >> hAxis: {format: 'currency', prefix:"£", fontSize: '24'}, >> seriesType: 'bars', >> //series: {5: {type: 'line'}} >> }; >> >> >> >> >> var chart = new >> google.visualization.ComboChart(document.getElementById('chart_div')); >> chart.draw(data, options); >> } >> </script> >> <div id="chart_div"></div> >> </TD> >> >> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/c8a5b34b-bc66-4c6a-a914-2a71f73a08d3n%40googlegroups.com.
