How do I pass series data x-value range to a chart from a cell?

G

Guest

I have a series on a line chart (x-values "=Sheet1!$A$1:$A$10"). I also have
two worksheet cells (B1 & B2) that contain the start and end date for the
x-axis of the chart. I want to be able to link the chart series data to the
start and end date values so that the chart automatically adjusts when I
change the dates in the worksheet cells. I can create a string or address for
the x-values but how do I do not know how to pass this to the chart series??

I know I can do this using a macro, but I want to do it without macros so
that friends who use MicrosoftCharts (the cheap, no macro version of Excel)
can still use the charts.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart changes series when copied 1
How to create a bubble chart with more than 2 variables 0
chart x-axis values appear as a series 1
One extra x axis item that wont go away - can anyone help? 3
Placing an arrow on the series line in a line chart 5
How do I adjust marker spacing in Excel scatter plot? 1
Why does X axis become another data series? 2
Abstracting Error Bar Data From Charts 3

Top