Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
NWO NWO is offline
external usenet poster
 
Posts: 60
Default Trying to color every other X axis interval...

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Trying to color every other X axis interval...

X is the horizontal axis (the one that runs along the bottom).

Y is the vertical axis (the one that runs vertically from top to bottom on
the left hand side).

The way that I remember it is to look at the shape of the Y - the bottom
part of the Y runs vertically from top to bottom.

If my comments have helped please hit Yes.

Thanks!



"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Trying to color every other X axis interval...

X is the horizontal axis (the one that runs along the bottom).

Y is the vertical axis (the one that runs vertically from top to bottom on
the left hand side).

The way that I remember it is to look at the shape of the Y - the bottom
part of the Y runs vertically from top to bottom.

If my comments have helped please hit Yes.

Thanks!



"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Trying to color every other X axis interval...

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Trying to color every other X axis interval...

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO



  #6   Report Post  
Posted to microsoft.public.excel.charting
NWO NWO is offline
external usenet poster
 
Posts: 60
Default Trying to color every other X axis interval...

Hi.

I like ther Y example - thanks.

I'm using a line graph with 6 percetnage intervals along the Y axis and wish
to shade every other interval.

NWO

"trip_to_tokyo" wrote:

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #7   Report Post  
Posted to microsoft.public.excel.charting
NWO NWO is offline
external usenet poster
 
Posts: 60
Default Trying to color every other X axis interval...

Hi.

I like ther Y example - thanks.

I'm using a line graph with 6 percetnage intervals along the Y axis and wish
to shade every other interval.

NWO

"trip_to_tokyo" wrote:

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 70
Default Trying to color every other X axis interval...

Hi NWO.

I have put up a file for you at:-

www.pierrefondes.com

It is the first file on the home page.

I have played around with this to try and come up with what you want but
have drawn a blank.

I am assuming that, on the example, you are trying to have alternate colours
for the dates along the bottom of the graph (the X axis).

Steve



"NWO" wrote:

Hi.

I like ther Y example - thanks.

I'm using a line graph with 6 percetnage intervals along the Y axis and wish
to shade every other interval.

NWO

"trip_to_tokyo" wrote:

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #9   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Trying to color every other X axis interval...

Not in an Excel horizontal bar chart.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



trip_to_tokyo wrote:
X is the horizontal axis (the one that runs along the bottom).

Y is the vertical axis (the one that runs vertically from top to bottom on
the left hand side).

The way that I remember it is to look at the shape of the Y - the bottom
part of the Y runs vertically from top to bottom.

If my comments have helped please hit Yes.

Thanks!



"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

  #10   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Trying to color every other X axis interval...

This tutorial may help:

Highlight Certain Time Periods in a Chart
http://peltiertech.com/WordPress/hig...ds-in-a-chart/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



NWO wrote:
Hi.

I like ther Y example - thanks.

I'm using a line graph with 6 percetnage intervals along the Y axis and wish
to shade every other interval.

NWO

"trip_to_tokyo" wrote:

NWO, do you have a column chart (with 6 columns)?

Are you trying to put columns so that they are coloured, for example, red /
green / red / green / red / green ?

I am not sure what you are trying to do nor the type of chart with which you
are working.

Please clarify and I will see if I can help.

"NWO" wrote:

Trying to color every other X axis interval (I'm not sure what X and what's Y
- I want to shade every other area across the graph from top to bottom -
chart has 6 intervals) in a simple chart - is there an easy way to do this?

Thnak you.

NWO

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
x-axis Interval -markc Charts and Charting in Excel 1 August 19th 09 09:38 PM
Excel 2007 - change interval between labels on X axis artemis Charts and Charting in Excel 3 June 19th 08 01:28 PM
x-axis time interval John Charts and Charting in Excel 1 June 7th 08 02:23 AM
Formula used by Excel to determine y-axis interval in chart M Chin Excel Discussion (Misc queries) 1 November 6th 07 01:57 PM
Need to know the logic for determining the interval between Y axis labels [email protected] Charts and Charting in Excel 1 November 3rd 07 06:16 PM


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