Forum Discussion
Trend Lines
Nice one ImkeF, I just found that today and was planning on updating my oh-so-dated knowledge!
Anyone NOT having trend lines options show after the update for all type expected?
Note says " data in the following charts: line, scatter, bubble, column, area, and combo charts" and I have in scatter. But for a column or line chart no "Trend Line" as expected from the release notes and video.
Column chart options below.
- Anonymous10 years agoNot applicable
DouglasAPlummer Looks like it is also dependent on what field you are using in your x-axis. If you look closely in the video in the two examples, one is using time, the other a numeric value. I just tested this out and it didn't show up as a formatting option till I used one of those. (or, not a text field). Put another way, it needs an x-axis that it can actually draw a trend on.
- elf_ranger919 years agoFrequent Visitor
The trend line option still does not appear for me...
Instead of using month names on the x-axis, I´m using numerical values as was suggested in this thread. Furthermore, the type is set to continuous - but still having no luck!!
Any ideas?
- Greg_Deckler10 years agoCommunity Champion
It is the Clustered Column Chart that has it, not the Stacked. And for Line Chart and Clustered Column Chart, make sure that your X-Axis is set to "Continuous" and not "Categorical"
- DouglasAPlummer10 years agoNew Member
thank (again). Being able to do when categorical would be nice but this is a step in the right direction.
- Sean10 years agoCommunity Champion
Anonymous is absolutely right!
even your standard YYYY-MM is unfortunately but understandably not recognized
You have to start with a Date Column and then just keep Year and Month.
Month Numbers only - work though.