Help! Graph Issues!

[jebradec]

Hi, my question is about making graphs in excel 2007.

I am trying to make a graph based on data in an excel worksheet, but the data is not organized in numerical order on the graph, and I would like it to be organized in numerical order on the graph without messing up the order of the data in the worksheet.

How to put the data in the graph in numerical order without it affecting the data in the worksheet?

Let me know if that makes sense. Thanks,

-radec.

 

[Datsmart]

I would suggest you use some formula's on another worksheet that lists the data in sorted order, then aim your chart at that table.

Excel Workbook
	A	B
1	Col A	Col B
2	123	124
3	89	90
4	5	6
5	2	3
6	11	12
7	88	89
8	34	35
9	55	56
Sheet

Excel Workbook
	A	B
1	Sorted Columns
2	2	3
3	5	6
4	11	12
5	34	35
6	55	56
7	88	89
8	89	90
9	123	124
Sheet

 

[jebradec]

Hi, thank you so much for your reply. I understood your response, but I didn't understand the table that you showed afterward that was filled with formulas and how they would aid me in being able to manipulate my graphs the way I want.

This is the formula I am confused about:

=IF(Sheet1!A2,SMALL(Sheet1!$A$1:$A$9,ROW($A1:$A1)),"")

 

[Datsmart]

In my test workbook I put the first table in worksheet "Sheet1".
On worksheet "Sheet2", are the listed formulas, they will display as shown below. Note that they must reside in the same row numbers as the table they refer to on "Sheet1".
Your chart is built off of the table on "Sheet2" which contains the listed formulas. This table is not just a sorted copy of your original table. It is the formulas in those cells that do the Sorting.

Excel Workbook
	A	B
1	Sorted Columns
2	2	3
3	5	6
4	11	12
5	34	35
6	55	56
7	88	89
8	89	90
9	123	124
Sheet2

Any changes to the un-sorted original data tabel on Sheet1 will take effect on your "Sheet2" table and hence also on your chart.

Cell A2 contains the formula =IF(Sheet1!A2,SMALL(Sheet1!$A$1:$A$9,ROW($A1:$A1)),"")
Hope this clears up what I am suggesting.