Different background color depending on x-axis value

Hi!

Is there any way to have the background in a chart have differen
colors depending on x-axis values?

Like 
x-axis value 1-10 => blue background
x-axis value 10-20 => red background

Thank

--
RealRave
-----------------------------------------------------------------------
RealRaven's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3705
View this thread: http://www.excelforum.com/showthread.php?threadid=56778

0
8/3/2006 8:18:33 AM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
611 Views

Similar Articles

[PageSpeed] 5

Here are a few of the ways you can get custom background fills for your 
charts"

http://PeltierTech.com/Excel/Charts/ChartIndex.html#Background

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"RealRaven" <RealRaven.2byg7e_1154593204.8988@excelforum-nospam.com> wrote 
in message news:RealRaven.2byg7e_1154593204.8988@excelforum-nospam.com...
>
> Hi!
>
> Is there any way to have the background in a chart have different
> colors depending on x-axis values?
>
> Like
> x-axis value 1-10 => blue background
> x-axis value 10-20 => red background
>
> Thanks
>
>
> -- 
> RealRaven


0
jonxlmvpNO (4558)
8/3/2006 4:48:10 PM
Amazing, it looks really great. Weird that I have to fool excel int
doing this, feels like something they (m$) would like us to be able t
do :)

Thanks

--
RealRave
-----------------------------------------------------------------------
RealRaven's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3705
View this thread: http://www.excelforum.com/showthread.php?threadid=56778

0
8/3/2006 8:04:16 PM
Reply:

Similar Artilces:

Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that have subtotals associated with them (automatically generated via the pivot table). I need to to take the subtotals for 2009 and 2010 and calculate the % difference. Here's a screenshot of what I'm talking about: http://home.comcast.net/~wilsoch/PercentDiff.jpg Is this even possible or am I going to have to do this manually? Hi I have'nt seen the screenshot as am at work , go to Pivot Table>Formulas>Calculated Field wilsoch@comcast.net wrote: >This is what I need to do: I have rows of ...

Changing color of a range of cells dending up on a value in anothr
Hi, I need to change the color of a range of cell, depending up on the value in another cell. I am using Excel 2003. And it allows me to give only 3 conditions when using conditional format. But I have 7 differnt conditions. Thanks in advance for any help. Srajes. Unless you move to XL2007, you will need to use VBA. Here are some sites that will help http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm http://www.mvps.org/dmcritchie/excel/condfmt.htm Alternatively, there is an add-in here http://www.xldynamic.com/source/xld.CFPlus.Download.html -- Steve "Srajes&qu...

color according to name
If the name "Dave" appears in B3, I want C3-Z3 to have a blue background color. What's that formula? dzelnio Select C3:Z3 and Format>Conditional Formatting>Formula is: =$B3="Dave" Format to Blue. Gord Dibben MS Excel MVP On Thu, 05 Jul 2007 10:47:29 -0700, dzelnio <dzelnio@yahoo.com> wrote: >If the name "Dave" appears in B3, I want C3-Z3 to have a blue >background color. > >What's that formula? > >dzelnio Works great! Thanks Dave On Jul 5, 1:39 pm, Gord Dibben <gorddibbATshawDOTca> wrote: > Select C3:Z...

Ending balance doesn't equal market value
I am using MS Money 2004. In my portfolio the Contributions ($) Market Value amount is showing a negative amount, but Today's Balance shows a zero Ending Balance. How do I get them to both show tha same number? In microsoft.public.money, Eggman wrote: >I am using MS Money 2004. In my portfolio the Contributions ($) Market Value >amount is showing a negative amount, but Today's Balance shows a zero Ending >Balance. How do I get them to both show tha same number? Try File->RepairMoneyFile->QuickFileRepair Look for future transactions. ...

x-y Line Graph question
I have a line graph. X is dates and Y is numeric data. I am plotting 12/1/2005 through 1/30/2006. The problems is my series does not start at the "left most" point of 12/1/2005, it is shifted slightly. And the line does not end at the "right most" point of 1/30/2006. Any ideas will be appreciated. thanks! XL has two distinct chart types even though they look similar, the XY Scatter chart and the Line chart. There is no XY Line graph. I believe you have a Line graph. Double-click the x-axis and from the Scale tab uncheck the 'Value (Y) axis crosses betwe...

Lowest value in a selection of data
Hi What formula would I use to find the lowest value in a selection of data i.e. B49:E52. Much Appreciated Brian =MIN(B49:E52) -- Gary''s Student - gsnu2007a Jumping in here... Is it possible to know the address of the cell containing the minimum value? John. You can use the MATCH function to locate the (relative) position, but if you have more than one value which are minima then it will only find the first. Pete On Nov 16, 7:23 pm, John Google <JohnGoo...@hotmail.co.uk> wrote: > Jumping in here... > > Is it possible to know the address of the cell containin...

How to change background color of a window that has been created.
I need to change the background of a window that has been created, can you help? Hello Jerry, > I need to change the background of a window that has been created, can > you help? > Answer depends upon the type of window. Typically you can do this in OnEraseBkgnd. Certain controls respond to WM_CTLCOLOR and yet some other, like CButton, need to be owner drawn to change the color. If you have a generic CWnd, you can always specify the brush in the window class; so no special painting is needed. This is good when you know that the background will have one color all the time. -...

Adding Values From Different Tabs
Is there a way to add values from different tabs on the same spreadsheet? For example A2 from tab 1 and A2 from tab 2 -- Flipkid2 ------------------------------------------------------------------------ Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984 View this thread: http://www.excelforum.com/showthread.php?threadid=398184 Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi formula: =Sheet1!A2+Sheet2!A2 note the name of the sheet is followed by "!" to indicate it is a shee name. HTH Bruc -- swatsp0 ------------...

X-axis labels in Excel!
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Why isn't there an option any longer to change the x-axis labels from default numbers to source data from the spreadsheet? This is ABSURD! Who on earth doesn't label their x-axis??? Leave it to Microsoft to leave out something so basic and essential. At least everything looks pretty. In article <ee989b5.-1@webcrossing.caR9absDaxw>, eabboud@officeformac.com wrote: > Why isn't there an option any longer to change the x-axis labels from default > numbers to source data from the spreadsheet? > > This is ABSU...

Use Outlook Client when domain user name different with email acco
Hello, I have a question about using Outlook Client. If the domain user login name is different with email account which belong to a same person, is it possible to install / login with the Outlook client? e.g domain user : degdom\apple email account: applewatson@deg.com One of my client is facing in this situation. I just want to have some preparation before install Outlook Client for him. Thanks for any help! Hi Huimc, It shouldn't be a problem if the AD user is the same used to start Outlook and connect to CRM. You may want to check the email adress in CRM if the ema...

Display only duplicate values and delete UNIQUE Items
All I have a very large list of data and on a monthly basis i need to display only the duplicate items in a spreadsheet. I would like to do this in VBA and then run it as a macro on the spreadsheet. Alot of the sites that i have seen only show how to removed the duplicates. Excel 2007 has a function which removed all duplicates but so far i have found nothing that only displays the duplciates.... any ideas anyone? Assuming that the field you use to determine uniqueness is column A, you can put this formula in a helper column: =3DIF(COUNTIF(A:A,A2)>1,"Duplicate","Unique&...

Is there a way to Sort Data by font color or cell shading?
I have a long list of items that I sort by either item number or date depending on what I'm looking for. From time to time these items status will change and I will gray them out by just shading the background of the cell gray. Is there a way I can sort these items by the background/shading of the cell first and then the secondary sort be date? So all the cells which contain gray shading will be first in the list (sorted by date if possible) then the rest of the list without the gray shading will follow by date as well. Thanks. Take a look at this link: http://www.cpearson.c...

color coding events
I would like to color code events on my daily calendar and wonder if there is a way to change the color of text on individual events On 3/7/2010 6:27 AM, jcurtis wrote: > I would like to color code events on my daily calendar and wonder if > there is a way to change the color of text on individual events Which version of Outlook? Outlook 2007 introduced colored categories and I use them daily for color-coding events. Prior to Outlook 2007, colored labels were your option: http://office.microsoft.com/en-us/outlook/HP030848441033.aspx Additional information: htt...

Printing Font color
Can anyone tell me how to print normal text in a color other than black? Have tried all types of fill for text (both black and gray) and still always prints BLACK. Ellen this would be an issue of your printer driver - not Publisher. The issue you describe is unknown in Publisher. However, we can get to the bottom of it for you. What version of Windows and Publisher are you using? Is this 'normal text' in a Text Frame or WordArt? What brand and model of printer are you using? -- ...

Reinstalling Office X After a HD Failure
My HD had a catastrophic failure and I had to replace it. Now I am = trying to=20 reinstall Office X from the most recent upgrade disk (I've purchased = every=20 upgrade for as long as I have been using Office) and the software is = looking=20 for the older version for upgrade verification. =20 I've systematically "browsed" to the CDs from every earlier verion I = have, but=20 the verification is not accepted. Suggestions? Rodney Dixon <anonymous@discussions.microsoft.com> wrote: > My HD had a catastrophic failure and I had to replace it. Now I am trying to > ...

Assigning a color to a cell
I saw some other post about kind of the same problem but not this way. I have a risk evaluation formula in a cell. Output range is between 1 and 9 If between 1 and 3, I want to assign the color lightgreen to it If between 4 and 6 I want to assign the color yellow to it and red if 7 to 9. Is this possible within the Function use ? If not, How can I apply that automatically ? a macro ? How ? TIA Hi See menu Format > Conditional format. It has a very helpful wizard. (Remember to consider what should happen at exact numbers 3, 6, 9.) HTH. Best wishes Harald "Junkyard Engineer&qu...

Running macros for different cells at the same time
Hi all, Is it possible to run different macros on different cells at the sam time? If so how do I go about setting it up? Cheers Michae -- Message posted from http://www.ExcelForum.com Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany > Hi all, > > Is it possible to run different macros on different cells at the same > time? If so how do I go about setting it up? > > Cheers > > Michael > > > --- > Message posted from http://www.ExcelForum.com/ Yes it is possible to run different m...

Exclude like values with a JOIN?
I have the following query: SELECT dbo.qry_UV_CARS_PlateX_ShouldBeValued.Yl_iD FROM dbo.qry_UV_CARS_PlateX_Valued RIGHT OUTER JOIN dbo.qry_UV_CARS_PlateX_ShouldBeValued ON dbo.qry_UV_CARS_PlateX_Valued.Yl_iD = dbo.qry_UV_CARS_PlateX_ShouldBeValued.Yl_iD WHERE (dbo.qry_UV_CARS_PlateX_Valued.Yl_iD IS NULL) And I have another secondary table containing the same field as Yl_iD. What I want to do is have my main query exclude all the Yl_iD values that are in my secondary table. What JOIN and criteria will do this? Many thanks.....Jason WHERE Yl_iD N...

increment a value by 1
How do I increment, automatically, a cell by 1 if a condition is met? If one of my cells reaches 10k I want another cell to increment by 1. Can anyone help me if this function can be done? Thank you, Ron Do you want the increment only when it changes from below 10K to above 10K, or anytime is is above 10K? -- Gary's Student "Workshops" wrote: > How do I increment, automatically, a cell by 1 if a condition is met? If one > of my cells reaches 10k I want another cell to increment by 1. Can anyone > help me if this function can be done? > Thank you, Ron Increm...

MC++ & C# generate different XML
Hi, I've been trying a long time now to generate some XML using MC++ and XmlSerializer. I have a piece of C# code that produces exactly what I want, but I simply can't get the MC++ code to write the same thing. Below I have included two minimal compilable samples that illustrate my problem. The C# code produces this XML: <?xml version="1.0" encoding="utf-8"?> <LandXML xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Units name="unit1" /> <Units name="un...

conditional formatting: separating rows with differing values
Hi, Need help with conditional fomatting. What I need: I got a worksheet with 950 rows and 5 columns. The first row contain the headers. Columns A, B, D and E contains unique values. But the column C contains text values which repeats sequentially for 6-7 rows and changes thereafter. Now I want to put up a line (using border) through the whole row dividing this transition row. My Idea: Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so on till 2 consequtive values differ. Now divide the 2 rows using the border formatting option in conditional formatting dialog box. So...

multiply value based on quantity
I am trying to calculate a discount price based on quantity purchased. For example if someone buys 20 widgets they pay $4.00 each for them, if they buy 50 widgets they pay $4.00 each for the first 20, then $3.50 each for the next 30, 100 widgets - $4.00 first 20, $3.50 next 30 and $3.25 for the other 50.............. Any hope? Here's a way with quantity in A2: =MIN(A2,20)*4+MAX(MIN(A2-20,30),0)*3.5+MAX(MIN(A2-50,50),0)*3.25 Regards, Per "Bigfoot3910" <Bigfoot3910@discussions.microsoft.com> skrev i meddelelsen news:524D35AE-4524-46A3-A963-703CB385C7F...

Macro: Find matching DATA, copy correspondently values into another list
Okey guys - please advise me on this. (There was unfortunately no quick response to my latest problem - and I begun to swim... However - that brought me out on deep VBA-water...again - and now need a life buoy (metaphorical spoken)). The core of my macro problem is to look for all the values in column A (Range A5:A??) in Sheet "BOARD" (not bored!!!) that match values in another list placed in column A in sheet "LIST". When finding the match I will copy correspondent celle.value in column D / sheet "BOARD" into column B in sheet "LIST" - this w...

Setting series values on Excel Chart
Hi I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet. Unable to set the Values property of the Series class. The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid. My code is: 1. Retrieve selected data from database and place it at the top of the sheet 2. Add The Chart 3. Iterate through the data (amount can be variable depending upon user inputs) For j as i...

how read value from last selected cell? It is possible? how get adress last selected cell?
for example. I write to cell A11 value "hello", and next: IF I click "ENTER" or IF I click mouse in any different cell (A15, B10, C1... free choice) I wont to display: MsgBox "Value in your last selected cell = ???" On this example MsgBox "Value in your last selected cell = hello" it is very important for me. I try with event of Private Sub Worksheet_Change(ByVal Target As Range) ?? but :( thanks everybody, Andrzej Andrzej You have little choice but to use the Worksheet_Change() event as the Worksheet_SelectionChange() event, give you the cell ...