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
|
|||
|
|||
Loosing 1 month on my chart
I am using Excel 2000
I created a simple line chart with l line of information for a 30 month period. I have the chart as big as I can get it, but I can not get the last month to show on the chart. All of the dates on the X Axis are size 7. Nothing looks even crushed. I have seen charts with 4+ years of information and the chart looks crushed. Why can't I get this last month to show on the chart. I check my Souce data and all of the cells are picked up as I want them. Can anyone suggest what I should do next? I would really appreciate it. Aurora |
#2
|
|||
|
|||
Loosing 1 month on my chart
Maybe if you change the axis of the chart - right-click on the axis, then choose Format Axis, then choose Axis, and enter an appropriate range - one greater than the latest date...your last date might show up then. Regards Mike -- Mikeopolo ------------------------------------------------------------------------ Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570 View this thread: http://www.excelforum.com/showthread...hreadid=510278 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart Property Confusion | Arturo | Charts and Charting | 4 | December 16th, 2005 05:13 AM |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
Need a stacked bar chart with each stack representing a month | KellyT@HLI | Charts and Charting | 3 | June 14th, 2005 01:41 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |