LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.charting
James Silverton
 
Posts: n/a
Default Cell formats and grid lines.

Jon wrote on Wed, 23 Nov 2005 09:46:24 -0500:

JP
http://peltiertech.com/Excel/Charts/...Gridlines.html
JP http://peltiertech.com/Excel/Charts/AddLine.html

JP What you might want, if the zero is between the min and
JP max, is to keep the axis (a distinct line) at zero, but
JP change the label position to "Low" so they're out of the
JP way.

?? Some clipping of less relevant information <<<<<<<<<<<<<

?? A rather similar problem has intrigued me for some time:
is it
?? possible to change a gridline for a particular value to a
?? different thickness or color? I can find a use for this
?? when the zero value for the y-axis is inside the chart
?? rather than along an edge.

Thanks again Jon for a very prompt reply and some fascinating
information. I will have to read your two web pages very
carefully. It is a pity that the Excel programmers have never
thought of implementing my idea.

James Silverton.



 
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
Missing x-axis labels on chart in XL97 Rob Hick Charts and Charting in Excel 2 November 18th 05 05:40 PM
Rotating a chart, and more.. adambowie Charts and Charting in Excel 2 November 14th 05 09:47 AM
Create a combo chart with two of the same chart types Mark Parent Charts and Charting in Excel 2 October 14th 05 01:28 AM
How to remove a data point in a chart? Vicky Charts and Charting in Excel 6 July 15th 05 05:27 PM
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 10:55 PM


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