| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
no trendline option available
I have 3 sets of data for different conditions. When charted, 2 sets have the
option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
Hi,
What type of chart do you have? Are all 3 data sets in the same chart? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
It is a line chart.
The three data sets are in three separate charts. "Andy Pope" wrote: Hi, What type of chart do you have? Are all 3 data sets in the same chart? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
The 3rd one is not a 3d style chart is it?
-- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... It is a line chart. The three data sets are in three separate charts. "Andy Pope" wrote: Hi, What type of chart do you have? Are all 3 data sets in the same chart? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
no 3d. just a line with value markers at each data point.
"Andy Pope" wrote: The 3rd one is not a 3d style chart is it? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... It is a line chart. The three data sets are in three separate charts. "Andy Pope" wrote: Hi, What type of chart do you have? Are all 3 data sets in the same chart? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
If you want to email example workbook I will have a look see.
Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... no 3d. just a line with value markers at each data point. "Andy Pope" wrote: The 3rd one is not a 3d style chart is it? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... It is a line chart. The three data sets are in three separate charts. "Andy Pope" wrote: Hi, What type of chart do you have? Are all 3 data sets in the same chart? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MJA" wrote in message ... I have 3 sets of data for different conditions. When charted, 2 sets have the option to "add trendline", but the third set (with more "ups and downs' in the data) does not have the option available. There are no empty cells in the source data nor are there multiple series on the chart. Any ideas why I don't have the ability to add a trendline on this set of data. At first, I thought it was perhaps because there isn't a high enough order in the polynomial fit, but paring down the data so there is only one peak did not help (that is, add trendline was still not an available action). |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
no trendline option available
Thanks for the example.
Whilst I have yet to discover what is different about that chart the fix is simple. Change the series to a column chart and then back to a line. You should now be able to add trendline. If I do discover the reason I will post it. Cheers Andy Andy Pope wrote: If you want to email example workbook I will have a look see. Cheers Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option. | Excel Worksheet Functions | |||
| why can't I click on the trendline option in my chart? | Charts and Charting in Excel | |||
| Why is a logarithmic not always an option under trendline type? | Charts and Charting in Excel | |||
Linear Mode
