Secondary Axis Lines Not Displaying in Excel

[ewhite3344]

Hello,

The secondary axis series titled 'Social Media Posts Goal', 'Clicks Goal', 'Engagement Goal', and 'Website Pageviews Goal' have dotted lines that are not showing up on my chart on sheet 'Charts FY22'. I attached a photo titled 'secondary axis lines example' to give you an example of how I'm trying to format this desired chart. I was successful at implementing this type of chart in the past. Please let me know.

Thank you.

[MrShorty]

If I understand correctly, the data series in question consist of a single data point each and are formatted to show only lines without markers. The data series are there (you can see them if you format them to also have a data marker), but connecting lines are only shown when there are multiple data points to connect. In this case, each data series is a single point, so there is nothing to connect with a dashed line.

I'm not sure what solution to recommend, because I am not sure what you have done in the past with these and any other requirements you might have. One way or another, I would expect that you will need to either do something to have at least 2 data points per series for these horizontal line series, or you will need to create the chart as a column + scatter combo chart and use the horizontal error bars to draw the horizontal dashed lines.

How would you like to proceed?

[bsalv]

i remade the graph and it worked immediately, but i have no idea why your chart isn't working.
If you want a graph for the quarters, you have to hide the months !