Chart data

[Sharbat]

Hello


Please let me clarify about the nature of data on EXCEL SHEET which I
wanted to display on Graph.
There are three columns in an Excel sheet each of them contains data.
In column 1 (Continent) there is only one row that is North America.
In column 2 (Country) there is only one row that is USA.
In column 3 (States) there are several rows like (Taxas, Kansas,
NewYork etc).

Now I wanted that on an EXCEL Graph, first the data from (Continent
column) would display that is North America
Then below the North America the data from second
column (Country) would display that is USA.
Then below the all the data from third column
(States) would display that are Taxas, Kansas, etc.

So thats the scenario, which I wanted to display on Graph.

Your kind comments will be appreciated.

Kinds Regards

Sharbat

 

[Debra Dalgleish]

It's not clear to me where the numbers are, but if you have headings in
columns A, B and C, and numbers in column D, you could create a pivot
table to summarize the data, and a pivot chart from the summary.

There's a PivotTable intro and some links on Jon Peltier's web site:

http://www.peltiertech.com/Excel/Pivots/pivotstart.htm