LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 461
Default charting, adding a random gridline

That's okay, I got a chuckle out of it.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



cate wrote:
On Dec 8, 8:03 pm, cate wrote:
On Dec 6, 2:47 pm, Jon Peltier wrote:



Excel's gridlines are associated with the axes they cross, with spacing
equal to the major or minor spacings of these axes. You can't add just
one arbitrarily located gridline.
You can add reference lines to a chart:
Add a Line to a Column or Line Charthttp://peltiertech.com/Excel/Charts/AddLine.html
Arbitrary Gridlines and Axis Labelshttp://peltiertech.com/Excel/Charts/ArbGridLabel.html
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.http://peltiertech.com/
cate wrote:
I have fished thru the objects, looked at my macros, and I cannot
figure out how to add a random gridline on a chart. Is it as
convoluted as some postings seem to make this, or is there a method
I'm overlooking the obvious, some very simple... chart.gridline(axis,
val)?
Thank you

Thank you very muck


oops, that typo doesn't look very nice ... much

 
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
Adding random noise to data Augabog Excel Worksheet Functions 3 April 3rd 23 12:10 PM
Excel is adding 2 rows of data source together when charting Leona Charts and Charting in Excel 1 February 25th 10 08:30 PM
Adding Random Numbers Gary''s Student Excel Worksheet Functions 23 June 17th 08 06:08 PM
Adding random #s in a range to equal a specific # Jeff Excel Programming 1 April 25th 08 08:51 PM
Custom gridline - one single gridline at a specific value Barry Guidry Charts and Charting in Excel 3 September 14th 07 07:04 PM


All times are GMT +1. The time now is 08:52 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"