#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default data points

I have a scatter chart with the following info : sales price, square
footage, and subdivision. With the x and y axis being sales price and square
footage. There are some entries where i will have several sales in one
subdivision and i would like all those points to show up in the same color.
How do i get several points to show up in the same color instead of excel
assigning each entry a new label?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default data points

Include all the related points in the same data series, rather than as a
different data series for each point.
--
David Biddulph

"affordablegreen" wrote in
message ...
I have a scatter chart with the following info : sales price, square
footage, and subdivision. With the x and y axis being sales price and
square
footage. There are some entries where i will have several sales in one
subdivision and i would like all those points to show up in the same
color.
How do i get several points to show up in the same color instead of excel
assigning each entry a new label?



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 select all data points/data labels at once (to format)? kippers Charts and Charting in Excel 3 April 4th 23 12:39 PM
connect line to data points with missing data in between ziak Charts and Charting in Excel 4 April 4th 23 10:35 AM
How to Format numbers from percentage points to basis points Robaroo Excel Discussion (Misc queries) 2 April 3rd 23 06:58 PM
Formatting data series - line between certain data points only alan_m Charts and Charting in Excel 0 September 20th 07 05:16 PM
excel 2007, how to select a data point and cycle through data points [email protected] Charts and Charting in Excel 5 September 4th 07 12:29 PM


All times are GMT +1. The time now is 01:36 AM.

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"