Skip to main content
Solved

Can Chart Generator axis values be displayed in scientific notation?


notmyname
Participant
Forum|alt.badge.img

Hello,

I am using the chart generator with some small numbers to make a scatterplot. I can't figure out how to display the axis values in scientific notation. See the example chart generator output image below using some made up values. The Y axis values range from 1.0e-3 to 1.0e-9. I would like to change the axis values to scientific from decimal.

 

 

Thanks for the help

 

 

Sheet1 

Best answer by daveatsafe

Hi @David Birkigt​,

You can use the StringFormatter transformer with a Format String of e to convert your numerical values to scientific notation strings before the ChartGenerator. The ChartGenerator will interpret these correctly and create a chart similar to this:

Screen Shot 2023-03-01 at 3.15.22 PM

View original
Did this help you find an answer to your question?

2 replies

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • Best Answer
  • March 1, 2023

Hi @David Birkigt​,

You can use the StringFormatter transformer with a Format String of e to convert your numerical values to scientific notation strings before the ChartGenerator. The ChartGenerator will interpret these correctly and create a chart similar to this:

Screen Shot 2023-03-01 at 3.15.22 PM


notmyname
Participant
Forum|alt.badge.img
  • Author
  • Participant
  • March 2, 2023
daveatsafe wrote:

Hi @David Birkigt​,

You can use the StringFormatter transformer with a Format String of e to convert your numerical values to scientific notation strings before the ChartGenerator. The ChartGenerator will interpret these correctly and create a chart similar to this:

Screen Shot 2023-03-01 at 3.15.22 PM

Appreciate the help. I messed around with e and TCL (not enjoyable) for a bit. I am not quite getting the format I want so I'll probably pursue another charting option.

Thanks


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings