Forum Discussion
Chart plotting values in wrong place according to axis?
I have this chart in excel that is being produced from a table in another tab in the same workbook. It has simple date in one column and values in another. When I hover over the plots for the MailChimp line the value displays correctly (e.g. 1344 in the screengrab for 25/6/26 datapoint) but the plot is between 2500 and 3000 on the graph according to the axis. This isn't happening for any other lines on the graph for any other values, only for the Mailchimp line. Any ideas how I can rectify this or what could be going wrong?
2 Replies
I suspect you have used a Stacked line chart. Select a regular one in stead.
Thanks a lot Riny_van_Eekelen - you're exactly right. I've switched to a regular line chart and now have data displaying where it should be! Appreciate your help.
