PC Review


Reply
Thread Tools Rate Thread

Conditional chart w/different x-axis crossing

 
 
=?Utf-8?B?SmlsbA==?=
Guest
Posts: n/a
 
      29th Apr 2004
I created a conditional chart which shows two different types of columns... one column type shows actual # days to sign a contract, and the other shows contracts that are still pending and # days it's taken so far. these are based on a fairly involved formula, with about 150 contracts

I'd like to compare the # days that's it's taken (for both types of columns) and compare them to the goal for how long they SHOULD take (2 days)

When I use a normal column chart, changing the Category (X) axis crosses at setting (i.e. 2) works as I want it to... showing contracts that were signed within 2 days below the line, and contracts that have taken longer above the line. But when I apply the same setting to the conditionally formatted chart, nothing happens

Suggestions

Thanks for your help

Jill.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
y axis crossing - three series -markc Microsoft Excel Charting 0 18th Aug 2009 09:34 PM
Crossing Axis Values Alonso Microsoft Excel Charting 2 29th Jul 2009 05:04 PM
Secondary Axis not crossing at zero =?Utf-8?B?VEMyMDA0?= Microsoft Excel Charting 4 1st Nov 2007 02:42 PM
chart secondary axis crossing with x axis Matthew Dodds Microsoft Excel Programming 1 30th Nov 2005 09:34 PM
Conditional font in chart axis Urban Microsoft Excel Charting 2 16th Sep 2004 01:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:31 AM.