Advanced Multi variable analysis and Graphs
- Thread starter Adarsh S
- Start date
ashakantasharma
New Member
https:/ /www.educba.com/3d-plot-in-excel/
Chihiro
Excel Ninja
Standard 3d plots packaged with Excel is woefully inadequate, is more of a visual fluff, and detracts from narrative rather than add insight to data.
There are few options.
1. Create XYZ matrix and plot based on it. However, without curve calculation, it will give gross misrepresentation of data.
For MESH format curving, you can use XYZ Mesh.
http://www.graytechnical.com/blog/xyz-data-inside-excel/
2. Use python extension for Excel and leverage data visualization libraries. Such as seaborn, plotly, matplotlib etc.
For python extension I'd recommend xlwings CE. I've only ever used it for static charting, so not sure if interactive chart is possible or not.
https://www.xlwings.org/
If you can live with chart being outside of Excel, you can use plotly to share/publish online for interactive chart.
https://plotly.com/python/xlwings/#online-dashboards-with-excel--python--plotly
For animated chart, you can use matplotlib to create and export it to animated gif. Then you'd follow steps in link below to show it in Excel.
http://www.repairmsexcel.com/blog/insert-gif-in-excel
3. 3 axis 2d plot. Basically you overlay 2nd chart on top of another, but use shape group to line them up and move and size as one.
There are other options, but these I've used before.
There are few options.
1. Create XYZ matrix and plot based on it. However, without curve calculation, it will give gross misrepresentation of data.
For MESH format curving, you can use XYZ Mesh.
http://www.graytechnical.com/blog/xyz-data-inside-excel/
2. Use python extension for Excel and leverage data visualization libraries. Such as seaborn, plotly, matplotlib etc.
For python extension I'd recommend xlwings CE. I've only ever used it for static charting, so not sure if interactive chart is possible or not.
https://www.xlwings.org/
If you can live with chart being outside of Excel, you can use plotly to share/publish online for interactive chart.
https://plotly.com/python/xlwings/#online-dashboards-with-excel--python--plotly
For animated chart, you can use matplotlib to create and export it to animated gif. Then you'd follow steps in link below to show it in Excel.
http://www.repairmsexcel.com/blog/insert-gif-in-excel
3. 3 axis 2d plot. Basically you overlay 2nd chart on top of another, but use shape group to line them up and move and size as one.
There are other options, but these I've used before.
Chihiro
Excel Ninja
But... 'multiple variables analysis' doesn't really tell me much.
What sort of data are you dealing with, and what sort of analysis did you have in mind?
If you want to do statistical analysis (Multiple Regression Analysis). You should read up following series.
http://www.real-statistics.com/multiple-regression/multiple-regression-analysis/
For this type of analysis, separate plot for each independent variable is warranted (either done as panel chart, or as individual chart).
What sort of data are you dealing with, and what sort of analysis did you have in mind?
If you want to do statistical analysis (Multiple Regression Analysis). You should read up following series.
http://www.real-statistics.com/multiple-regression/multiple-regression-analysis/
For this type of analysis, separate plot for each independent variable is warranted (either done as panel chart, or as individual chart).
Last edited: