| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
charting, adding a random gridline
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
charting, adding a random gridline
cate;577994 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 In what way is the gridline random? Its value? (where it crosses an axis?) Vertical/Horizontal? Its appearance - colour, thickness etc. What's the aim of the random gridline? An evasive animal, random; throw something at him and he'll probably duck. -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=159772 Microsoft Office Help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
charting, adding a random gridline
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 Chart http://peltiertech.com/Excel/Charts/AddLine.html Arbitrary Gridlines and Axis Labels http://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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
charting, adding a random gridline
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
charting, adding a random gridline
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding random noise to data | Excel Worksheet Functions | |||
| Excel is adding 2 rows of data source together when charting | Charts and Charting in Excel | |||
| Adding Random Numbers | Excel Worksheet Functions | |||
| Adding random #s in a range to equal a specific # | Excel Programming | |||
| Custom gridline - one single gridline at a specific value | Charts and Charting in Excel | |||
Linear Mode
