Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am using Excel 2000
When I create Line Charts - usually for a year's time frame, my last part of the line (tail) on the chart goes directly to the bottom of the chart. For example: My line goes up and down for jan, feb, mar, (per the data) but because there is no data for apr, the line goes directly to the bottom of the graph (0) at apr. I understand why this happens, but someone told me there is a way to stop this line at the end of the data without the tail hanging down. I know that I could just highlight just the cells with data. but this in turn stretches my time frame (jan,feb& mar) across the whole chart instead of showing the whole year (jan - dec). Does anyone know how to get rid of just the tail on the chart? I know this is a small thing, but it bugs some people around here. I would certainly appreciate any help someone can give me. Aurora |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bar Chart To Line Chart for last 3 points only | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |