Title: h axis format Last modified: August 30, 2016 --- # h axis format * Resolved [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/) * Hello, * I would like to change the h axis format to number with currency sign. I looked at the google dev page [https://developers.google.com/chart/interactive/docs/customizing_axes](https://developers.google.com/chart/interactive/docs/customizing_axes) * and tried to implement it. I am using code but, w/o any success with format change. Everything else works fine. * [gdoc key=”my sheet” chart=”Line” title=”Total equity” chart_height=”450″ chart_h_axis_format =”$#,###”] * Is it wrong? * F. * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) Viewing 10 replies - 1 through 10 (of 10 total) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6806946) * `chart_h_axis_format` is not a [recognized attribute](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/other_notes/). * From the Google documentation: * > You can control the formatting of label numbers with `hAxis.format` and `vAxis. > format`. For instance, `{hAxis: { format:'#,###%'} }` displays the values “ > 1,000%”, “750%”, and “50%” for values 10, 7.5, and 0.5. * And from [this plugin’s FAQ](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/faq/): * > Some configuration options call for an Object value. For these, the shortcode > attribute value should be a JSON object. * So, putting the two together, you probably meant: * ``` chart_h_axis='{"format":"$#,###"}' ``` * Thread Starter [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6806965) * Thanx for the answer. However the code you provided is not working either 🙁 * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6806968) * Right above the button you pressed to post this message, this forum asks you: * > Did you include a link to your site, so that others can see the problem? * Thread Starter [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6806969) * Sorry for that. Here is the link to the particular table: [http://letstradetogether.com/overall-results/](http://letstradetogether.com/overall-results/) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6806997) * When I use `chart_h_axis='{"format":"currency"}'`, it works for me. * Thread Starter [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807000) * Not working either, this is my whole code that I am using `[gdoc key="LINK TO SHEET" chart="Line" title="Total equity from November 16, 2015" chart_height=" 450" chart_h_axis='{"format":"currency"}']` * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807002) * On the page you linked, the output of your shortcode is: * >
data-chart-type=”Line” title=”Total equity from November 16, 2015″ class=”igsv- > chart” id=”igsv-0-Linechart-1K9g-CeUog8zoyLOlqT9wrGl_ENfp6_j37eM4aspml2E”> * Note that there is no `data-chart-h-axis` attribute. So I must conclude that you have not actually tried adding the attribute to the shortcode, or there is a cache active on your site that loads old versions of your pages. (You’ll probably want to disable that, if so.) The bottom line, when I add the `chart_h_axis` attribute [as I describe](https://wordpress.org/support/topic/h-axis-format?replies=8#post-7750339), it does work; the horizontal access is formatted with the currency of the browser’s locale. * Thread Starter [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807003) * I really put it there. I don’t know why it is not working. I cleared my cache several times. * This is the pic from my wordpress: [http://postimg.org/image/4gqx7dzr5/](http://postimg.org/image/4gqx7dzr5/) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807004) * Like I said, I can’t reproduce that issue. The shortcode works for me using your Sheet data. * Thread Starter [Ferikes](https://wordpress.org/support/users/ferikes/) * (@ferikes) * [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807005) * Ok, thank you for the effort Meitar. Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘h axis format’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) * 10 replies * 2 participants * Last reply from: [Ferikes](https://wordpress.org/support/users/ferikes/) * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/h-axis-format/#post-6807005) * Status: resolved