Trying to color every other X axis interval...

NWO · External Since: Dec 09, 2005 Posts: 34

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

trip_to_tokyo · External Since: Jun 28, 2009 Posts: 15

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

trip_to_tokyo · External Since: Jun 28, 2009 Posts: 15

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

NWO · External Since: Dec 09, 2005 Posts: 34

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

trip_to_tokyo · External Since: Jun 28, 2009 Posts: 15

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

Jon Peltier · External Since: Feb 01, 2004 Posts: 179

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

Jon Peltier · External Since: Feb 01, 2004 Posts: 179

This tutorial may help:

Highlight Certain Time Periods in a Chart
http://peltiertech.com/WordPress/highlight-certain-time-periods-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