A table to act like a chart

[-emma-]

Hi All,

I am creating a sheet that collates various parts data (from a data tab) and displays them in a more visual way (on a information tab) automatically.

Most of the data is displayed in either a pie chart or a bar graph which is fine but some of the data needs to be displayed in a table format. Is there a function that will pull all the data through from the data tab and place it in a table?

Thanks for your help in advance.

Emma x

 

[oldbrewer]

yes in sheet1 cell A1 put =sheet2!A1

now whatever is in sheet 2 is displayed in sheet1

so choose what cells you want to bring across

 

[PlusX EAI]

A pivot table