A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trying to color every other X axis interval...



 
 
Thread Tools Display Modes
  #1  
Old September 24th, 2009, 06:09 PM posted to microsoft.public.excel.charting
NWO
external usenet poster
 
Posts: 59
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  
Old September 24th, 2009, 07:28 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_2_]
external usenet poster
 
Posts: 79
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  
Old September 24th, 2009, 07:43 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_2_]
external usenet poster
 
Posts: 79
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

  #4  
Old September 24th, 2009, 08:47 PM posted to microsoft.public.excel.charting
NWO
external usenet poster
 
Posts: 59
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

  #5  
Old September 25th, 2009, 06:27 AM posted to microsoft.public.excel.charting
trip_to_tokyo[_2_]
external usenet poster
 
Posts: 79
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

  #6  
Old September 26th, 2009, 12:01 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
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

  #7  
Old September 26th, 2009, 12:02 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:56 PM.


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