{"id":4120,"date":"2017-08-21T14:33:23","date_gmt":"2017-08-21T14:33:23","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-to-format-numbers-with-google-charts-in-netsuite-for-enhanced-visualization-2\/"},"modified":"2026-07-28T18:26:25","modified_gmt":"2026-07-28T18:26:25","slug":"comment-mettre-en-forme-les-nombres-avec-google-charts-dans-netsuite-pour-une-meilleure-visualisation","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-mettre-en-forme-les-nombres-avec-google-charts-dans-netsuite-pour-une-meilleure-visualisation\/","title":{"rendered":"Comment mettre en forme les nombres avec Google Charts dans NetSuite pour une meilleure visualisation ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Apprenez \u00e0 appliquer un formatage num\u00e9rique personnalis\u00e9, y compris une mise en couleur des valeurs n\u00e9gatives, aux colonnes de donn\u00e9es dans Google Charts afin d\u2019obtenir une repr\u00e9sentation plus claire des donn\u00e9es.","ga_short_answer":"Pour mettre en forme les nombres dans Google Charts, instanciez l\u2019objet google.visualization.NumberFormat avec les options souhait\u00e9es, telles que negativeColor et negativeParens. Appliquez ensuite ce formateur \u00e0 des colonnes de donn\u00e9es sp\u00e9cifiques \u00e0 l\u2019aide de formatter.format(data, columnNumber). Veillez \u00e0 ce que la valeur de allowHTML soit d\u00e9finie sur true lors de la cr\u00e9ation du graphique afin d\u2019assurer un rendu stylistique correct.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019un formatage sp\u00e9cifique des nombres dans Google Charts afin d\u2019am\u00e9liorer la lisibilit\u00e9 des donn\u00e9es, en particulier lorsqu\u2019il s\u2019agit de valeurs n\u00e9gatives. Le rendu par d\u00e9faut des graphiques peut ne pas fournir les rep\u00e8res visuels souhait\u00e9s, tels qu\u2019une coloration distincte ou la mise entre parenth\u00e8ses des nombres n\u00e9gatifs, ce qui rend l\u2019interpr\u00e9tation des donn\u00e9es moins intuitive.","ga_solution":"Pour appliquer un formatage num\u00e9rique personnalis\u00e9, tel que la mise en forme des valeurs n\u00e9gatives, dans Google Charts, utilisez l\u2019objet google.visualization.NumberFormat. Commencez par cr\u00e9er une instance du formateur en sp\u00e9cifiant les options de formatage souhait\u00e9es :\n```\nvar formatter  new google.visualization.NumberFormat({\n    negativeColor: 'red',\n    negativeParens: true\n});\n```\nUne fois le formateur cr\u00e9\u00e9, il doit \u00eatre appliqu\u00e9 individuellement aux colonnes de donn\u00e9es concern\u00e9es.\n```\nformatter.format(data, columnNumber);\n```\nRemarque importante : pour que l\u2019option de couleur des valeurs n\u00e9gatives s\u2019affiche correctement, l\u2019option allowHTML doit \u00eatre d\u00e9finie sur \u00ab true \u00bb lors du trac\u00e9 du graphique.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:33:23-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Number Formatting with Google Cart","ga_ans_id":"ANS-0461","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"SuiteScript Development","footnotes":""},"ga_category":[108,23,108],"ga_audience":[10],"ga_difficulty":[92],"class_list":["post-4120","qa_entry","type-qa_entry","status-publish","hentry","ga_category-developpement-suitescript","ga_category-suitescript-development","ga_audience-developer-suitescript","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":108,"label":"D\u00e9veloppement SuiteScript"},{"value":23,"label":"SuiteScript Development"},{"value":108,"label":"D\u00e9veloppement SuiteScript"}],"ga_audience":[{"value":10,"label":"Developer\/SuiteScript"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4120\/revisions"}],"predecessor-version":[{"id":6041,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/4120\/revisions\/6041"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=4120"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=4120"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=4120"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=4120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}