I run a program that refreshes a chart data each time it is run and produces a trendline. This trendline is a 3rd order polynomial. A data label is shown that is automatically formatted in scientific notation to 2 decimal places. This information is not accurate for my purposes as I need the data to at least 6 decimal places. How do I set the default to 6 decimals. I have tried to record a macro to capture a manual change but this does not do the trick. Any thoughts?
This is what I got when I recorded a manual change....
Change the chart, seriescollection, and trendline references to suit.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
You would be better off using LINEST to get the values on the worksheet. Select a range 7 cells wide, and array-enter
=LINEST(yValues, xValues^{1,2,3,4,5,6})
The order of appearance of coefficients is x6, x5, ..., x, b
Entia non sunt multiplicanda sine necessitate
Thank you AlphaFrog! Works perfectly. Interested to know how you were able to record a manual change but I couldn't?
You're welcome. I really don't know why it recorded for just me.Originally Posted by Bluedog1212
Also checkout shg's clever solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks