| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
A mind of its own?
I'm trying to express this data as a simple scatter graph with points. It is for analysing car sales so I can bid at an auction. Usually when I try this it makes a scattering of data Price (Y), Km (X).. This time it groups it around a series of points which is meaningless to me. There are 30 entries ranging from x 17,000 to 250,000 and (y) 4770 to 7170. The Series entries are Name A, =A!$B$3:$B$33 =A!$C$3:$C$33 This is the data: 92000 5470 55655 6470 88060 5020 17000 7170 82000 5920 94000 5570 96000 5600 64000 5570 91292 5720 114000 5020 89401 4770 90900 5470 114000 5270 250000 6470 97000 6520 83135 6420 57000 6570 31040 6420 114000 6120 79060 6670 92000 5470 90200 6620 84062 6620 118000 5470 97000 6520 92751 5170 113000 5570 114000 6020 66406 7120 85000 6320 78177 5870 What's going on here?????? Thanks John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph with a mind of its own | Excel Discussion (Misc queries) | |||
| Mind Gone Blank!! | Excel Worksheet Functions | |||
| Mind Gone Blank!! | Excel Discussion (Misc queries) | |||
| VBA Conditional Formatting has mind of it's own! | Excel Worksheet Functions | |||
| Help - Loosing my settings and my mind. | Excel Discussion (Misc queries) | |||
![JohnH[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
