Looking up existing data ranges

[storm1979]

Hi, early last year I created a dashboard. I'm pretty new to excel and so I had to look up various techiniques on the internet.

We're now in 2008 and a small section of the dashboard has stopped working (late millenium bug perhaps ). The chart which was designed to select data from the past 1/7/30/356 days is not showing anything.

I'm pretty certain that this is caused by a fault in the data series for the chart, however the only information I can dig up in terms of source data is: =Dashboard.xls!YValues and =Dashboard.xls!XValues. I'm sure that XValues and YValues are pre-defined ranges but I don't know what they are or what data they cover. If I could find this out I could make a start on resolving the problem.

I'm sure the answer is very obvious, but does anyone know how I can see what the X & Y Values are?

[royUK]

i think you need to zip & attach the workbook.

[robert111]

insert, name define and select xvalues from the list, refers to at the bottom will give you the data range