|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-13-2008, 10:42 AM
|
|||
|
|||
|
Help with Charting Data
Hi, I could use someones help.
I have a list of data in 3 columns, one is a list of models of cars, the second and third column are the corresponding price and wheelbase. i.e. Honda Accord / 2,800 mm / $32,400 Honda Civic / 2,700 mm / $26,380 . . . I am trying to show price on the Y axis, wheelbase on the X axis and then have the "name" of the model displayed in the corresponding xy location within the chart. I need to plot about 40 models along the wheelbase and price grid. I tried pivot table but all it gives me is the 'count' but I need the name displayed. Please help. 
|
|
#2
08-13-2008, 11:11 AM
|
|||
|
|||
|
For each row of data you need to add a series to a scatter chart. Use the name of the car cell for the series name.
Then on chart options select Series Name under Data Labels. Example attached. Laura
|
|
#4
08-13-2008, 03:46 PM
|
||||
|
||||
|
You may find Rob Bovey's chart labeler addin useful for assigning cell text to data labesl.
http://www.appspro.com/Utilities/ChartLabeler.htm
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
