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 
Ads 
#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...dsinachart/  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  

