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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|