Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Maz Page
 
Posts: n/a
Default On a scatter chart show two point have same value

I have created a scatter chart, but often where only one point is shown on
the graph, it actually represents two or more points with the same values.
How can I show this on the chart?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You could add a couple of columns to your data, and create a bubble
chart. For example, if your values are in cells A2:B50 --

In D2, enter a formula to concatenate the values: =A2&"-"&B2
In C2, enter a formula to count the occurrences of each combination:
=COUNTIF($D$2:$D$50,D2)

Copy the formulas down to the last row of data

Select columns A:C and create a bubble chart.


Maz Page wrote:
I have created a scatter chart, but often where only one point is shown on
the graph, it actually represents two or more points with the same values.
How can I show this on the chart?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 08:31 PM
How do I show gridlines over a chart area? Chris M Peterborough UK Charts and Charting in Excel 1 December 9th 04 02:06 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Scatter chart x axis tick mark lables so Charts and Charting in Excel 2 December 2nd 04 06:06 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 07:44 PM


All times are GMT +1. The time now is 02:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"