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
|
|||
|
|||
Line Chart
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 |
#2
|
|||
|
|||
Line Chart
Replace the blank cells with =NA() which displays as #N/a but is ignored by
nchart OR Select chart; use Tools | Options; open Chart tab; specify what is to happen to empty cells best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Aurora" wrote in message ... 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 |
#3
|
|||
|
|||
Line Chart
Thank you for trying to help. 1. I can't replace the cells with =NA()
because these cells have a formulas in them waiting for data to be entered to calculate the formula. I check the tools idea - but everythings appears to be as it should be. Empty cells - "not plotted" is checked and "Plot visual cells only" is checked. Do you have any other ideas? Aurora "Bernard Liengme" wrote: Replace the blank cells with =NA() which displays as #N/a but is ignored by nchart OR Select chart; use Tools | Options; open Chart tab; specify what is to happen to empty cells best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Aurora" wrote in message ... 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 |
#4
|
|||
|
|||
Line Chart
A cell with a formula is NOT empty even if nothing is displayed.
If your formula is something like =IF(test, math_expression, ""), change it to =IF(test, math_expression, NA()), Let me know if this helps -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Aurora" wrote in message ... Thank you for trying to help. 1. I can't replace the cells with =NA() because these cells have a formulas in them waiting for data to be entered to calculate the formula. I check the tools idea - but everythings appears to be as it should be. Empty cells - "not plotted" is checked and "Plot visual cells only" is checked. Do you have any other ideas? Aurora "Bernard Liengme" wrote: Replace the blank cells with =NA() which displays as #N/a but is ignored by nchart OR Select chart; use Tools | Options; open Chart tab; specify what is to happen to empty cells best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Aurora" wrote in message ... 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line chart from multiple worksheets | Paul B. | Charts and Charting | 2 | September 21st, 2005 11:46 PM |
Creating a line chart with two X-axes!! | JaVaughn | General Discussion | 1 | June 30th, 2005 01:36 PM |
Line chart - date line association gone mad! | Johannes Czernin | Charts and Charting | 5 | January 17th, 2005 08:48 PM |
Trying To Add a Line to an Excel chart using variable cell values | Larry Campbell | Charts and Charting | 2 | January 24th, 2004 05:31 PM |
Plotting a datapoint on an existing Line chart | Tushar Mehta | Charts and Charting | 0 | November 23rd, 2003 01:08 AM |