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
|
|||
|
|||
X axis restricted in scatter charts
Excel Guru's please help.
I am working with an excel spreadsheet that was created by an individual who is no longer around for consultation and I am having difficult with the x axis scale in a scatter chart. The spreadsheet is a tool used for the company's risk managment approach. Risks are currently tracked by assessing their likliness to occur and the consequence if they do occur. These values are mulitplied and provide one risk number that is tracked on the scatter chart. Currently two lines are plotted (estimated vs. actual) Then for each mitigation step we determine we have 6 fields to fill in - estimated completion date, expected likelihood, expected consequence, actual completion date, actual likelihood, actual consequence. The problem I am having however is that I can not figure out how to extend the values of the x axis. Currently it plots every date through 2008, however the company would like to track through 2012. If I enter a date of 2020 a dotted line shows up and runs off the chart, but I can not figure out how to change the scale to include later dates. Any suggestions? Thanks for your support and time. |
#2
|
|||
|
|||
Double-click on the X-axis
Select the Scale tab Check the Auto box, to the left of Maximum Click OK kimd wrote: Excel Guru's please help. I am working with an excel spreadsheet that was created by an individual who is no longer around for consultation and I am having difficult with the x axis scale in a scatter chart. The spreadsheet is a tool used for the company's risk managment approach. Risks are currently tracked by assessing their likliness to occur and the consequence if they do occur. These values are mulitplied and provide one risk number that is tracked on the scatter chart. Currently two lines are plotted (estimated vs. actual) Then for each mitigation step we determine we have 6 fields to fill in - estimated completion date, expected likelihood, expected consequence, actual completion date, actual likelihood, actual consequence. The problem I am having however is that I can not figure out how to extend the values of the x axis. Currently it plots every date through 2008, however the company would like to track through 2012. If I enter a date of 2020 a dotted line shows up and runs off the chart, but I can not figure out how to change the scale to include later dates. Any suggestions? Thanks for your support and time. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
X axis on XY scatter chart | Jasmine | Charts and Charting | 5 | August 12th, 2004 11:22 PM |
Excel Charts - Value Y axis scale - locking values to preventchanging | Andy Pope | Charts and Charting | 0 | June 22nd, 2004 04:31 PM |
Scatter Charts | Aurora | Charts and Charting | 6 | May 22nd, 2004 02:42 AM |
excel charts w/secondary Y axis | curtis | Charts and Charting | 3 | March 23rd, 2004 09:53 PM |
Two axis Bar charts in Excel | Harvey Randell | Setting up and Configuration | 0 | December 19th, 2003 01:09 PM |