<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/custom-r-charts-coming-to-excel/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2018/05/powerbi-custom-visuals-in-excel.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>This week at the BUILD conference, Microsoft <a rel="nofollow" href="https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel" target="_blank">announced</a> that Power BI custom visuals will soon be available as charts with Excel. You'll be able to choose a range of data within an Excel workbook, and pass those data to one of the built-in Power BI custom visuals, or one you've <a rel="nofollow" href="https://github.com/Microsoft/PowerBI-Visuals/" target="_blank">created yourself using the API</a>.</p>
<p><a rel="nofollow" href="http://a0.typepad.com/6a0105360ba1c6970c0224e038fa08200d-pi" target="_blank"><img border="0" alt="Excel custom visuals" title="Excel custom visuals" src="http://a0.typepad.com/6a0105360ba1c6970c0224e038fa08200d-800wi"></a></p>
<p>Since you can <a rel="nofollow" href="https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">create Power BI custom visuals using R</a>, that means you'll be able to design a custom R-based chart, and make it available to people using Excel — even if they don't know how to use R themselves. There also many <a rel="nofollow" href="https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&page=1&src=office" target="_blank">pre-defined custom visuals available</a>, including some familiar R charts like <a rel="nofollow" href="https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380817?tab=Overview" target="_blank">decision trees</a>, <a rel="nofollow" href="https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380905?tab=Overview" target="_blank">calendar heatmaps</a>, and <a rel="nofollow" href="https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381492?tab=Overview" target="_blank">hexbin scatterplots</a>.</p>
<p>For more details on how you'll be able to use custom R visuals in Excel, check out the blog post linked below.</p>
<p>PowerBI Blog: <a rel="nofollow" href="https://powerbi.microsoft.com/en-us/blog/excel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals/" target="_blank">Excel announces new data visualization capabilities with Power BI custom visuals</a></p>
</div>
	<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2018/05/powerbi-custom-visuals-in-excel.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/ycnDeyG8ic4" height="1"></a></div>