Forum Discussion
April Update - Trend Lines
cmfisher82 Did you see this post? Could what you are experiencing fall into what is discussed there, or is this different?
Thanks - I did not see that post.
Good news and bad news though - changing to continuous x-axis worked in adding the trend line, but unfortunately this removes a lot of the week number labels at the bottom of my bar chart. Obviously, this makes the chart much less readable/functional at a glance. Are you aware of a way to add the labels back to each bar along the x-axis?
cmfisher82 yeah, that's odd. I tested out months in a year and the best I got was every other column even though there is plenty of space to put the x-axis value... But that seems to be across visuals regardless of whether or not I'm using the trend. I am not aware of a way to force it to show all values on the axis. :(
Anonymous - Thanks for trying. I'll leave this up here to see if anyone else has ideas.
On a related, but unrelated to this specific topic question - I currently have to create separate bar charts for the number of items opened by week number and the number of items closed by week number. Obviously these share a common x-axis (week number), but the values for opened/closed should be unique for each week.
When I try to combine these into a single bar chart using a clustered column chart, the count does not work correctly for closed. Every week matches the count of open. For example, let's say I have 156 items opened in week 1 and 86 items closed in week 1. If I create separate charts, this works fine. However, if I try to combine this into a single chart, I get 156 opened and 156 closed (rather than 86 closed as it should be.
Any idea on what could be happening here or how to fix it? Sorry, I know I'm a bit off topic to my original post.
