ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Loosing 1 month on my chart (https://www.excelbanter.com/charts-charting-excel/70468-loosing-1-month-my-chart.html)

Aurora

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

Mikeopolo

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



All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com