 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2008Multiple Colors on Area Charts
I would like to know if it is possible to have two different colors in the plotted area of an area chart. In the end, I would like to have the color for numbers less than 0 be one color and greater than 0 be second color. Thanks Hi Have a look at Jon's page on horizontal bands. http://peltiertech.com/Excel/ChartsHowTo/HorizBands.html Cheers Andy  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info >I would like to know if it is possible to have two different colors in the > plotted area of an area chart. In the end, I would like to have the color > for numbers less than 0 be one color and greater than 0 be second color. > Thanks More specifically, is there a way to only change the color in the shaded area of an area chart within specific ranges? The line on the graph rolls above and below zero and I want the colors above and below zero to be differnt colors. I know I can create two differnt series and plot the data as different colors however, if there is a way to make the chart using one series I would like to do that. Thanks! Sarah > I would like to know if it is possible to have two different colors in the > plotted area of an area chart. In the end, I would like to have the color > for numbers less than 0 be one color and greater than 0 be second color. > Thanks If I understand you then I think the answer is no. You can not colour an individual point in an area chart. You would need to use multiple series. But even with multiple series the transition between points may not be as expected. Cheers Andy SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info > More specifically, is there a way to only change the color in the shaded > area [quoted text clipped - 13 lines] >> for numbers less than 0 be one color and greater than 0 be second color. >> Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.