Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change axis info on radar charts | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |