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

sharbat

New Member
Joined
Mar 17, 2004
Messages
6
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

sharbat

New Member
Joined
Mar 17, 2004
Messages
6
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

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
so your wanting to graph...

what does your data look like??.. something like this??...
Book1
ABCD
1NorthAmericaUSAAlabamaarethere
2Alaskaanynumbers
3Arkansasinthis
4Californiacolumn?
5Maryland
6Minnesota
7NewMexico
8NewYork
9Oregon
10RhodeIsland
11SouthDakota
12Texas
13Washington
14Wisconsin
Sheet2
 

sharbat

New Member
Joined
Mar 17, 2004
Messages
6
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

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,307
Messages
5,600,869
Members
414,411
Latest member
Snowmanaus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top