LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Need to create a comparative scatter plot of several items

I'm using scatter plots to compare various technical specifications of 20
products.
One example is price v. storage capacity, with price on the x-axis and
storage capacity on the y-axis. Each product will be represented as a point
on the graph, based on its price and capacity.

Now for the tricky part: I want all of the data points ("markers") to be the
same shape and color. And I want to use the "series name" as each point's
data label. In other words, each point is its own "series".

There doesn't seem to be an easy way to do this in Excel. If I plot the data
as a single series, I can't easily associate the "product name" with each
point (I can add text next to each point, but... argh... aren't computers
supposed to work for *us*? :).

I can plot each point as an individual series, but then I have to manually
"Add" each data point to the graph... click, click, click... then reformat
each point so they're all the same... click, click, click... then add data
label and change it to "series name"... click, click, click. Did I mention
that the "repeat" command does not work on most changes made via "Format Data
Series..."? Grrrr...

Or is there an easier way?
 
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 to create scatter plot Melissa Excel Discussion (Misc queries) 6 December 17th 08 03:34 AM
xy scatter plot Andrew Excel Discussion (Misc queries) 2 November 4th 08 07:28 PM
How to Automatically Create Scatter Plot Charts Chris Gregory Charts and Charting in Excel 8 October 13th 06 03:35 AM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM
how do I create a 3 dimensional plot, for example XYZ scatter plo. pleasehelp Charts and Charting in Excel 1 January 28th 05 10:09 PM


All times are GMT +1. The time now is 11:03 PM.

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

About Us

"It's about Microsoft Excel"