Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-13-2019, 12:10 PM
RhondaPCanada RhondaPCanada is offline Windows XP Office 2010
Novice
 
Join Date: Feb 2019
Posts: 3
RhondaPCanada is on a distinguished road
Default Scatter Charts

Hi,



Is anyone familiar with creating scatter charts in excel? I have the data but it is not plotting the way I am wanting to.

I need someone to explain where data goes to get the desired outcome.

Help!

Thanks.
Reply With Quote
  #2  
Old 02-13-2019, 03:37 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 514
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

Without a sample file it's hard to give an exact answer without something to work with. What are you trying to accomplish?

Anyway, here are a few sites you can reference as aides.

http://www.andypope.info/charts.htm
https://peltiertech.com/Excel/Charts/ChartIndex.html
Reply With Quote
  #3  
Old 02-13-2019, 04:02 PM
RhondaPCanada RhondaPCanada is offline Windows XP Office 2010
Novice
 
Join Date: Feb 2019
Posts: 3
RhondaPCanada is on a distinguished road
Default Scatter Charts

That is understandable for sure.

The data I am trying to portray is just a pricing comparison on various terms (month to month, 1, 2, 3 and 5 year) with 5-6 different companies.

Some of the companies don't have pricing for some of the terms, so I think I can just leave those blank. Is that correct?

I am not sure how to enter the data into a spreadsheet to get it to show on the scatter properly. I want the legend to be the 5 or 6 different companies with a scatter points referencing each of the companies and their associated pricing for each of the term.

For example, company A has pricing on a 1 & 3 year term where company B has pricing for 2 & 3 year term.

How do I enter this into the excel spreadsheet? And what columns and rows so I highlight before choosing the scatter chart.

Hoping this is all somewhat clear!

thanks
Rhonda
Reply With Quote
  #4  
Old 02-13-2019, 04:47 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 514
jeffreybrown will become famous soon enoughjeffreybrown will become famous soon enough
Default

I still believe a tutorial is what you should read up on.

Here's one example...

https://www.ablebits.com/office-addi...er-plot-excel/

I can't write anything better than the tutorials on line.

If you have a sample built we can surely show you how to get the chart you desire, but ultimately you are the only way who knows what the data should be saying.
Reply With Quote
  #5  
Old 02-14-2019, 08:43 AM
RhondaPCanada RhondaPCanada is offline Windows XP Office 2010
Novice
 
Join Date: Feb 2019
Posts: 3
RhondaPCanada is on a distinguished road
Default Example of Data

Thanks. I read the tutorials but I the data is still not coming out as I would like. I have attached a screenshot of what I am trying to do. It is just pricing comparison between 5 companies. Some do different pricing based on term, others just do a single term price.

Hopefully you can see what I am doing wrong.

thanks
Rhonda
Attached Images
File Type: png Scatter Chart.png (9.7 KB, 7 views)
Reply With Quote
  #6  
Old 02-14-2019, 09:29 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 384
ArviLaanemets is on a distinguished road
Default

Do you mean, that for companies 2, 4 and 5 the price is same for all following months?

Then in your table you must have last price for every month (i.e. for every row in table).

From this follows, what about companies 1 and 3? Did they have any prices for currently empty months (p.e. was price same as last one entered, until it was changed)? When yes, then you have to fill in table all rows for all companies, when those companies had some price.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
After updating linked excel charts in publisher, all charts are moved effinglife Publisher 0 05-23-2017 02:27 AM
Scatter plot with only second y axis hanvyj Excel 0 07-26-2012 03:25 AM
4 quadrant scatter chart johnsongorj Excel 1 05-31-2012 12:08 PM
scatter chart gsrikanth Excel 1 03-07-2012 05:29 AM
How to create XY Scatter chart with quadrants Jamal NUMAN Excel 0 11-21-2010 04:37 PM


All times are GMT -7. The time now is 11:31 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft