ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X-axis customizing (https://www.excelbanter.com/charts-charting-excel/13373-x-axis-customizing.html)

schnett

X-axis customizing
 

I would like to only make the X=0 line on my excel chart darker. How do
I go about doing that ?


--
schnett
------------------------------------------------------------------------
schnett's Profile: http://www.excelforum.com/member.php...o&userid=12035
View this thread: http://www.excelforum.com/showthread...hreadid=345902


schnett


I am using XY scatter plot.


--
schnett
------------------------------------------------------------------------
schnett's Profile: http://www.excelforum.com/member.php...o&userid=12035
View this thread: http://www.excelforum.com/showthread...hreadid=345902


John Mansfield

Schnett,

Add a second XY series similar to below (this example shows a chart length
of 100 - yours needs to match your specs.). Remove the line markers and
adjust increase the line weight. Color the line black or whatever to match
the rest of your chart.

x y
100 0
0 0

----
Regards,
John Mansfield
http://www.pdbook.com


"schnett" wrote:


I am using XY scatter plot.


--
schnett
------------------------------------------------------------------------
schnett's Profile: http://www.excelforum.com/member.php...o&userid=12035
View this thread: http://www.excelforum.com/showthread...hreadid=345902



Tushar Mehta

If you have a y-axis and it is set at the default of x=0, double-click
it and from the Patterns tab adjust the format of the line as desired
(I'd start by picking a thicker line than the default).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I would like to only make the X=0 line on my excel chart darker. How do
I go about doing that ?





All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com