K
KingCreole
Hi Folks,
Quick query with regards to how data is read by a graph. I have a sheet
featuring the number of staff assigned to the call centre at 1/2 hour
points throughout the day. This data is stored in a sheet called 'Data'
and in cells D17, E17, F17 etc etc.
The data within this page is not very well presented as it is run
automatically from the system we use here so I have made a more
presentable table and graph. For the table for each 1/2 i simply
reference the cell in the data page so that all i have to do to update
the sheet week by week is paste fresh data in. Using =Data!D17 this
works as expected.
However if I then build a graph using this table it does not pick up
the actual figure. I have also tried referencing the number in the data
page (so the source data is =Data!D17, =Data!E17 etc etc) and this
again does not show any data. The graph does work fine if i manually
type the data into my table
Anyone know of a way around this?
Thanks in advance
Quick query with regards to how data is read by a graph. I have a sheet
featuring the number of staff assigned to the call centre at 1/2 hour
points throughout the day. This data is stored in a sheet called 'Data'
and in cells D17, E17, F17 etc etc.
The data within this page is not very well presented as it is run
automatically from the system we use here so I have made a more
presentable table and graph. For the table for each 1/2 i simply
reference the cell in the data page so that all i have to do to update
the sheet week by week is paste fresh data in. Using =Data!D17 this
works as expected.
However if I then build a graph using this table it does not pick up
the actual figure. I have also tried referencing the number in the data
page (so the source data is =Data!D17, =Data!E17 etc etc) and this
again does not show any data. The graph does work fine if i manually
type the data into my table
Anyone know of a way around this?
Thanks in advance