Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Xaver Hinterhuber
 
Posts: n/a
Default Colouring the plain at the zero line?

Hello,

I want to colour the plain at the zero level on the y-axis.

Is this possible?

Greets
Xaver


  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

Xaver,

If I'm understanding correctly, you can double-click on the X or Y axis to
bring up the Format Axis dialog box. Choose the color that you want in the
Patterns tab - Lines Color option.

Alternatively, you can add an additional series that runs up the Y axis at
the zero value. You can make color changes to this series just like you
would any others. The effect would be that you are coloring the Y axis at
the zero value.

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

"Xaver Hinterhuber" wrote:

Hello,

I want to colour the plain at the zero level on the y-axis.

Is this possible?

Greets
Xaver



  #3   Report Post  
Tushar Mehta
 
Posts: n/a
Default

Someone may prove me wrong, but assuming you have a 3D chart, you
cannot. The formatting capabilities of a XL 3D surface chart are
extremely limited.

--
Regards,

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

In article , says...
Hello,

I want to colour the plain at the zero level on the y-axis.

Is this possible?

Greets
Xaver



Reply
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
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 04:42 AM
Changing Line in line chart B Dubinsky Charts and Charting in Excel 1 January 21st 05 04:10 AM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 12:43 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"