Formula for a fixed experdential

[Andyc6]

Hello,

I need a formula where all the below figures have the experendential fixed to -11, any help much appreciated?

1.50E-11
5.20E-11
2.29E-10
7.00E-11
1.96E-10
4.05E-10
8.20E-11
8.20E-11
1.00E-11
8.00E-13
1.33E-10
3.12E-12
2.59E-14
3.27E-14
1.22E-11
8.40E-12

[sweep]

Hi,

If just for display purposes, you could use this:

Please Login or Register  to view this content.

where the required exp is -11

[Andyc6]

I want to then show this on a graph which at the moment dosent work

[AliGW]

In what way doesn’t it work? Care to share a bit more detail?

[Andyc6]

the formula displays as I need to see it however when i try and do a graph all i just get a single straight line

[MrShorty]

I have looked and not found a good way to fix exponents like this. However, how you display a number in the spreadsheet should not impact how it is charted (except where the chart axis has "number format linked to source", in which case the chart axis number format should match the cells' format). The only reason I can see for getting a single straight line (at 0) is if your numbers are actually text strings and not numbers, in which case the chart will treat them as 0.

Can you upload a simple example spreadsheet (go advanced -> Manage attachments -> upload file)?

[Andyc6]

Attachment with graph on, I appear to even lost the line now

[sweep]

So, to be clear, what you actually want is to plot the data you posted on a line chart whose y-axis runs from 0 to 45^-11?

[Andyc6]

yes, but i thought that once all my data is at -11 it would be quite easy

[sweep]

The simplest way I think is to mutliply the original data by 10^11. This guves you a set of numbers like so;

1.5
5.2
22.9
7
19.6
40.5
8.2
8.2
1
0.08
13.3
0.312
0.00259
0.00327
1.22
0.84

Plot these data, and label the axis RCarb,0-1 in [m²/s/kgCO₂/m³] x 10^-11

[Andyc6]

Thanks, that is giving me what im lookin for

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.