Tuesday, January 22, 2013 8:37 AM
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
Wednesday, January 23, 2013 6:57 PMModerator
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.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, January 27, 2013 4:31 PM
Wednesday, January 23, 2013 7:15 PM
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.
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