How to display data of diff of an excel sheet on graph?

[sharbat]

Hello Every one,


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 a 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 “USA”, all the data from third column (States) would display that are “Taxas, Kansas, etc”.

So that’s the scenario, which I wanted to display on Graph.

Your kind suggestions will be appreciated.

Kinds Regards

Sharbat

 

[Zack Barresse]

are you talking about drop down boxes, with a user-selection? maybe Tushar-Mehta's chart tutorials could get you started.

Hope this helps,

 

[sharbat]

hi,

I can't know about what you are saying. I am new On excel.
And my qusetion was simple, which I posted earlier.

I am looking forward to a useful suggestion.
This will be highly appreciated.

Thanks

Sharbat

 

[Zack Barresse]

so your wanting to graph...

what does your data look like??.. something like this??...

Book1
	A	B	C	D
1	NorthAmerica	USA	Alabama	arethere
2			Alaska	anynumbers
3			Arkansas	inthis
4			California	column?
5			Maryland
6			Minnesota
7			NewMexico
8			NewYork
9			Oregon
10			RhodeIsland
11			SouthDakota
12			Texas
13			Washington
14			Wisconsin
Sheet2

 

[sharbat]

Hi,

Thanks,

Yes the first three columns has the same information, which I am using.
Could you please let me idea how should we transfer this information on GRAPH.
If possible , give some example.

REgards

Sharbat

 

[Zack Barresse]

well, that is why i asked if there was any numbers in column D? you need something to graph besides words. are there numbers associated with the states? are there other countries? if so, how do you choose them?

if numbers, are they percentages, totals?

check the bottom of this (or any) page for a link to Colo's HTML Maker. if you could post your data, we would be able to see what you are working with, and give you a more accurate description of our solution(s). i hope this helps. just post more specific data, and let us take it from there.