Logaritmic scale in PowerWiew Scatter chart?

Question

Hi,

Is it possible to change the axle to logaritmic scale on a PowerView scatter chart in Excel 2013?
I try to do something like http://www.gapminder.org/world/#$majorMode=chart$is;shi=t;ly=2003;lb=f;il=t;fs=11;al=30;stl=t;st=t;nsl=t;se=t$wst;tts=C$ts;sp=5.59290322580644;ti=2011$zpv;v=0$inc_x;mmid=XCOORDS;iid=phAwcNAVuyj1jiMAkmq1iMg;by=ind$inc_y;mmid=YCOORDS;iid=phAwcNAVuyj2tPLxKvvnNPA;by=ind$inc_s;uniValue=8.21;iid=phAwcNAVuyj0XOoBL%5Fn5tAQ;by=ind$inc_c;uniValue=255;gid=CATID0;by=grp$map_x;scale=log;dataMin=283;dataMax=110808$map_y;scale=lin;dataMin=18;dataMax=87$map_s;sma=49;smi=2.65$cd;bd=0$inds=;example=75

Thank you!

Answer 1

Hi Jojx1,

Currently, the Logarithmic Scale property is not supported by the charts in Power View. Here, I would suggest that you submit a wish at https://connect.microsoft.com/sql.

Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.

Thanks for your understanding.

Regards,

---

Mike Yin
TechNet Community Support

Answer 2

Hi,

You can indirectly draw a logarithmic axis by adding a computed column DecimalLogY to your data source (dataset, view or table)

Obviously, DecimalLogY = Log10(Y)

Then you plot X against "DecimalLogY" instead of X against Y.

Notes :

1. LogY chart axis labels should be picked up from Y values, not from DecimalLogY ones.

Otherwise, one million dollars amounts will be shown as 6$ instead of 1000000$

2. SQL 2008 R2 provides LOG10 function, but other databases just provide LN or LOG (e.g. natural logarithm).

LOG10(x) can easily be calculated as LOG10(x) = LOG(x)/LOG(10)

3. Be aware that LOG10(x) gives an error for zero or negative values of x.

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu