A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

X, Plus, and Star marker styles do not show all data points



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2004, 07:36 AM
L Mehl
external usenet poster
 
Posts: n/a
Default X, Plus, and Star marker styles do not show all data points

In a scatter chart, the X, Plus, and Star styles simply mark the right end
of each string of data; data points to the left of that position don't show,
unless I use a background color different from the Chart's background.

The square, diamond, triangle, and circle styles show all the data.

Is there a property of these 3 problem styles I should set to make them
display like the 4 that work?

Thanks for any help.

Larry Mehl


  #2  
Old June 7th, 2004, 11:59 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default X, Plus, and Star marker styles do not show all data points

Larry -

I've never noticed a problem like that. You're saying the markers only
mark the last point in a series? Are these charts you're doing your VBA
experiments on?

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


L Mehl wrote:
In a scatter chart, the X, Plus, and Star styles simply mark the right end
of each string of data; data points to the left of that position don't show,
unless I use a background color different from the Chart's background.

The square, diamond, triangle, and circle styles show all the data.

Is there a property of these 3 problem styles I should set to make them
display like the 4 that work?

Thanks for any help.

Larry Mehl



  #3  
Old June 8th, 2004, 05:03 AM
L Mehl
external usenet poster
 
Posts: n/a
Default X, Plus, and Star marker styles do not show all data points

Hi Jon --

Yes, only the the last point in a sequence.

E.g., there are many x-values of 0 to 500 ; I see the grey background color
sticking out the left side of the chart but nothing indicating values until
500, where is one marker.

Similarly for the range 500 to 1100, except for no marker's background seen
at the right edge, because the x-scale max =1,300.

These are the charts I have been posting about for the last several months.

Larry


"Jon Peltier" wrote in message
...
Larry -

I've never noticed a problem like that. You're saying the markers only
mark the last point in a series? Are these charts you're doing your VBA
experiments on?

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


L Mehl wrote:
In a scatter chart, the X, Plus, and Star styles simply mark the right

end
of each string of data; data points to the left of that position don't

show,
unless I use a background color different from the Chart's background.

The square, diamond, triangle, and circle styles show all the data.

Is there a property of these 3 problem styles I should set to make them
display like the 4 that work?

Thanks for any help.

Larry Mehl





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.