title: how to add same y-values (from a cell) for different x values (dynamic) in VBA
body: <p>I have written a macro to plot graph for various dates. e.g. expenses for last 1 week. I want to draw a horizontal line in my chart/graph which should show the ideal expense (value provided by me in a cell). as the dates are dynamically changing and the vlue of the ideal expense is present in one cell, I am not sure how to create this series in my chart using VBA.</p>