Graphic Visualization of data on Excel

  • Thread starter Thread starter MATHEW KING
  • Start date Start date
M

MATHEW KING

Hi Tom,

Thanks for sharing your knwoledge with me.

Now I made the graph successfully using Pivottable Chart.

But I like to ask futher that,should we select the cell from another
sheet at the same time in order to make the graph.
Because I wanted to add the name of database (sheet 1) with
username,ids ( sheet 2).
Is that possible?

Also how should we hide all the contents or an Excelsheet of pivot
table ,which comes with pivot table chart.

Thanks.

Bilal.
 
Hi
not sure what you want to achieve with your first question :-) For the
secon one just select your sheets to hide and go to
'Format - Sheet - Hide'
 
Hi Frank,

Thanks for ur info.
I am using an oracle database.
Actually I wanted to dispaly the data from oracle on excel Graph(pivot
table chart).
I wanted that the information of users and the name of the database
would be shown on Excel Graph.

For Example:

Germany is the name of database and below the name of database,all
the name of users(Tom,Scott....etc) would be displayed on Excel Graph.

I am using several excel sheets in order to display the data from the
database.
As far as my knowledge, we can select the cells of a single sheet at a
time for
making a graph.
But I wanted to display the information on Graphs from two sheets.
Because the name of database is on sheet 1 and the name of users are
on sheet2.
It is the requirement.
I will appreciate if you suggest something about it,that how to select
the cells from two sheets in order to display the information on Excel
chart/graph.

Thanks

Kumar
 
Hi!

Excel will use any number (well, almost) of Series in its Source Dat
and it will take them from different worksheets.

The key is in addressing the data by its full name (e
Sheet1!$D$4:$D$30) when adding a Series. If you use the Chart Wizard
just select the sheet with the data and highlight|select it in th
usual way.


Al
 
Hi,

Thanks for ur info.
I am using pivot table chart.
As u discussed,Is that also work with pivot table chart?

Regards

Kumar
 
Back
Top