This one has a few of us stumped in the office. I am developing this for a nurse who doesn't have time to do much more than enter data. I don't want her to have to make a chart every time she enters data.
I have a range of data from =Sheet1!$A$3:$K$6 that I am using in a chart. Row 3 is attribute data like Date, Pain, Tiredness, Nausea, etc. The first column is the date, which I want to use as the X-axis charted over time.
I specify the range for the chart, and that works fine. The problem is when I want to extend the range to the next row. The date (which i have as Text because she wont be adding in every day, and leaving it as date fills in each missing date) changes to just a numerical number (1, 2, 3, 4, etc.). This then screws up the chart.
I need to use this as a template, as the nurse has multiple patients. Basically the question is, How do I extend the range so it automatically updates the chart?
I have a range of data from =Sheet1!$A$3:$K$6 that I am using in a chart. Row 3 is attribute data like Date, Pain, Tiredness, Nausea, etc. The first column is the date, which I want to use as the X-axis charted over time.
I specify the range for the chart, and that works fine. The problem is when I want to extend the range to the next row. The date (which i have as Text because she wont be adding in every day, and leaving it as date fills in each missing date) changes to just a numerical number (1, 2, 3, 4, etc.). This then screws up the chart.
I need to use this as a template, as the nurse has multiple patients. Basically the question is, How do I extend the range so it automatically updates the chart?