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? |
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 |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com