how to plot a graph in excel with formula

And Excel is the perfect tool to build advanced yet impactful charts for our analytics audience. There is no one size fits all chart and that’s why to create intuitive visualizations, it is imperative that we understand different types of charts and their usage. Usually, we can explain most things with a simple bar chart or a scatter plot but they don’t always fulfill the need. To convey the story to our management team, a key skill to learn is understanding different types of charts. I was able to level-up by improving my storytelling skills. There was a missing link in the whole scenario – storytelling. The stakeholders weren’t able to understand what I was trying to communicate to them. I have some news for you – this is actually not the core quality of a good analyst.

In fact, I know a lot of newcomers are fixated on this method of approaching things. I was completely focused on analyzing data and using statistical methods to build complex data science models when I first started my analytics journey.

Learn 3 advanced Excel charts here to impress your manager and build rapport with your stakeholders.Advanced Excel charts are a great way to create effective and impactful stories for our audience.

How to plot a graph in excel with formula