Plotting data in a secondary not the entire data series

[divakar_k]

Hi All,

Could you please help in letting me know how to post a data point of a data series in a seecondary access by keeping the other data points of the same data series in the primary access.

Tried changing the axis to secondary but the entire data series is shifted instead of the one point i wanted

Thanks
Divakar

For Ex -col A has forecast num of the locations and col b has actual numbers, i want to plot only one location's forecast and actuals in a secondary axis and all other forecast and actuals in the primary access.

 

[Asala42]

I don't think you can without separating that one data point into it's own data series.