Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
I have four identical charts looking at very similar data, three series per
XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Hi,
Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Is it possible that you have some extra data series -- with blank cells -- in these charts? scaling limits maybe, but I've never seen that Andy Pope wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Andy:
Thanks for your response. There are no extra data series in the charts. Each of the three listed as series are showing on the chart. There are no blank cells in any of the series. "Gklass" wrote: Is it possible that you have some extra data series -- with blank cells -- in these charts? scaling limits maybe, but I've never seen that Andy Pope wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Andy:
Thanks for your reply. The trendlines show up in the legend whether or not they show up on the chart. I have also tried deleting the data series in question (from the chart), then reinstalling it, then add a trendline. Same result. Scaling is automatic, and there is space above and below the data curve. Moving average will never exceed max/min points of basic data. Thanks again Norman "Andy Pope" wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Hi Norman,
If you can email me the file, off newsgroup, I will have a look see. Cheers Andy comfuted wrote: Andy: Thanks for your reply. The trendlines show up in the legend whether or not they show up on the chart. I have also tried deleting the data series in question (from the chart), then reinstalling it, then add a trendline. Same result. Scaling is automatic, and there is space above and below the data curve. Moving average will never exceed max/min points of basic data. Thanks again Norman "Andy Pope" wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Andy:
Thanks, will do. Norman "Andy Pope" wrote: Hi Norman, If you can email me the file, off newsgroup, I will have a look see. Cheers Andy comfuted wrote: Andy: Thanks for your reply. The trendlines show up in the legend whether or not they show up on the chart. I have also tried deleting the data series in question (from the chart), then reinstalling it, then add a trendline. Same result. Scaling is automatic, and there is space above and below the data curve. Moving average will never exceed max/min points of basic data. Thanks again Norman "Andy Pope" wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Hi Norman,
The problem is that the missing trend lines are not within the x scale you are currently displaying. Because the series lines are on the secondary axis and you have not supplied the range of secondary x axis values the chart is defaulting to using 1,2,3,4,5,6...... for the category (X) values. As the x axis is in fact dates the range of x values is 38497 to 38874. If you use the same range reference for the secondary axis category as the primary you trendlines will pop in to view. Use the Source Data option when you right click the chart to change this. You might want to look at this page which explains how to remove items from the legend, which will save you having to build your own. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy comfuted wrote: Andy: Thanks, will do. Norman "Andy Pope" wrote: Hi Norman, If you can email me the file, off newsgroup, I will have a look see. Cheers Andy comfuted wrote: Andy: Thanks for your reply. The trendlines show up in the legend whether or not they show up on the chart. I have also tried deleting the data series in question (from the chart), then reinstalling it, then add a trendline. Same result. Scaling is automatic, and there is space above and below the data curve. Moving average will never exceed max/min points of basic data. Thanks again Norman "Andy Pope" wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
some charts will not show trendlines
Andy:
Great! Thanks for the help on both issues. Norman "Andy Pope" wrote: Hi Norman, The problem is that the missing trend lines are not within the x scale you are currently displaying. Because the series lines are on the secondary axis and you have not supplied the range of secondary x axis values the chart is defaulting to using 1,2,3,4,5,6...... for the category (X) values. As the x axis is in fact dates the range of x values is 38497 to 38874. If you use the same range reference for the secondary axis category as the primary you trendlines will pop in to view. Use the Source Data option when you right click the chart to change this. You might want to look at this page which explains how to remove items from the legend, which will save you having to build your own. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy comfuted wrote: Andy: Thanks, will do. Norman "Andy Pope" wrote: Hi Norman, If you can email me the file, off newsgroup, I will have a look see. Cheers Andy comfuted wrote: Andy: Thanks for your reply. The trendlines show up in the legend whether or not they show up on the chart. I have also tried deleting the data series in question (from the chart), then reinstalling it, then add a trendline. Same result. Scaling is automatic, and there is space above and below the data curve. Moving average will never exceed max/min points of basic data. Thanks again Norman "Andy Pope" wrote: Hi, Are the trendlines appearing in the legend? Is it possible the trend line is beyond any scaling limits you may have set? Cheers Andy comfuted wrote: I have four identical charts looking at very similar data, three series per XY chart. I want trendlines (moving average) on all data series of all charts. One chart will not show any, others will show all three, some will show some but not all. No error messages, go through procedure of adding trendline, but it just doesn't show up. Search for hidden line with cursor, doesn't show. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of unusable charts? | Excel Discussion (Misc queries) | |||
Getting rid of unusable charts? | Charts and Charting in Excel | |||
add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22) | Excel Discussion (Misc queries) | |||
multiple charts similar size? | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |