Scatter Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am plotting a XY chart. I want that every point should be of different colour. Possibly I can define a range of 2 columns where column 1 contains the name for which the point is plotted and column 2 contains the colour for that point.
I have seen this being done in one chart but that person is no longer available for help
Please tell me how is it done
Thanks
Shilps
 
Hi Shilps -

Double click on the chart, and on the Options tab, check the Vary Colors
by Point box.

Now that you know where it's hidden, you'll become the resident expert!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
:) I wish I could, but theres a hitch. That option is disabled. The chart is a combination of 3 series. Could this be the reason?
 
That button only works if you have a single series on the chart.

You can format the points independently, though it gets a bit tedious.
Select the series, then select the point (two single clicks). Now press
Ctrl-1 to open the format dialog, and format the selected point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Can't I code it"? 'Coz its a dynamic chart. And its not possible to individually select a point and then format it 'cos the file will not be used by me but by a different user
 
Sure you can code it. Record a simple macro while you select and format
a few points to get the syntax and the constants, and look at the Object
Browser in the VB Editor. Are you going to apply formats based on
values, or just cycle through the combinations?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Thanks Jon for the trick of coding
Previosly I used to read and read , then by hit and trial write the code. Recording macro is a much easier way.
 
That's right. The code isn't perfect, it's usually pretty inefficient,
but it's usually a good starting point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top