How to make a scatter chart in excel 2010

#How to make a scatter chart in excel 2010 how to
#How to make a scatter chart in excel 2010 download

Please visit these pages for more resources on charting & analytics. We have posted several useful chart templates & ideas on. Also, tell us how you would have plotted same data? More Excel Charts for Analysis:Д®xcel charts are powerful visual tools for analysis and exploration. What do you think? Please share your opinion and ideas thru comments. What do you think about this chart?ДЄs I mentioned I really liked how this chart lays out the dynamics of market place without complicating or animating anything. You can see the chart construction steps in the downloaded workbook. I have prepared a simple excel chart template to help you create similar charts on your own.

#How to make a scatter chart in excel 2010 download

Download Competition Analysis Chart Templates: To make this chart, all the steps are same as above, just change your data to starting and end points, not the calculated ones. But a more descriptive option would be to show absolute position of each product at both times. The chart should look something like this:Д«onus Step: Making a scatter plot of absolute valuesДЄs you can see, the above chart only shows changes in market share and profit share of products between Q1-2008 and Q2-2010.

Add axis labels, position them accordinglyДЄnd you are done.

Add data labels to either starting or end points alone.

Set arrow symbol as the end-point style for these lines (new feature in Excel 2007 and above).

Add lines to scatter plot so that starting and end point are connected.

When you are done, it should look something like this: Now make starting values as zero and calculate ending values. Use cell references to extract the data for just first and last periods. Step 2: Re-arrange the data, so we get first and last values For the sake of example, we will use the same variables вЂ“ Market Share & Profit Share for 4 fictitious products вЂ“ A,B,C & D. In case of analytical charts like this, getting correct data is all important. Here is how you can construct similar business chart in excel.

It should present a story and poke our curiosity to ask questions (or address problems). and explore for answers.ДЄnd that is what a chart should do. The chart instantly lets me ask important questions like, вЂњSo what did Nokia do wrong?вЂќ, вЂњHow come RIM is also in the same league as Apple ( ie both market share and profit share went up) ?вЂќ etc.

#How to make a scatter chart in excel 2010 how to

But I cant figure out how to merge the two graphs Ive created, if thats indeed the way to do it. How do I do that I know how to create a single scatter plot by selecting data from one sheet and then creating a chart with that data (Insert -> Chart -> X Y (Scatter)).

It shows how new entrants like Apple have eroded the profit share for others. I want to create a scatter plot with both sets of data in it. It shows how then leader, Nokia, kept loosing profit share despite a tiny loss in market share. I like this type of chart because it clearly tells the story of what happened in mobile handset market between 20. The chart shown aside originally appeared in Asymco, shows how mobile handset market has changed between 2007 & 2010. Recently, Kaiser at Junk Charts pointed to a very effective business chart that shows the dynamics of competitive land scape with ease. How Mobile Handset Market Changed from 2007 to 2010?