| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart update according to high to low ranking
I have a chart that updates using a total line; values change daily and
update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Use an intermediate range for the chart source which links to the real data
but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Thank you John, I appreciate the response; I have not used =large before and
have looked at help on the function; however, I'm not clear as to how you are suggesting I use it to have it do the sort?? Thanks! -- Marv Lusk Boise Corporation "Jon Peltier" wrote: Use an intermediate range for the chart source which links to the real data but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Sorry, "Jon." :-(
-- Marv Lusk "MarvInBoise" wrote: Thank you John, I appreciate the response; I have not used =large before and have looked at help on the function; however, I'm not clear as to how you are suggesting I use it to have it do the sort?? Thanks! -- Marv Lusk Boise Corporation "Jon Peltier" wrote: Use an intermediate range for the chart source which links to the real data but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Here's an example. I have a table in sheet1, range A3:G2003. Column A is a
set of labels, as is row 3, the data is in B4 thru G2003, and I want to sort by column B. In Sheet2 I set up a table. Sheet2!B3 has the formula =Sheet1!B3, and this is dragged across to fill Sheet2!B3:G3. Sheet2!B4 has this formula: =LARGE(Sheet1!$B$4:$B$2003,ROW()-ROW($B$3)) This is copied and pasted into Sheet2!B4:B2003. This sorts the column in descending order. Sheet2!A4 has this formula: =INDEX(Sheet1!A$4:A$2003,MATCH($B4,Sheet1!$B$4:$B$ 2003,0)) This is copied and pasted into Sheet2!A4:A2003 and Sheet2!C4:G2003 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... Thank you John, I appreciate the response; I have not used =large before and have looked at help on the function; however, I'm not clear as to how you are suggesting I use it to have it do the sort?? Thanks! -- Marv Lusk Boise Corporation "Jon Peltier" wrote: Use an intermediate range for the chart source which links to the real data but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Here's another example:
http://peltiertech.com/WordPress/200...-for-charting/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message ... Here's an example. I have a table in sheet1, range A3:G2003. Column A is a set of labels, as is row 3, the data is in B4 thru G2003, and I want to sort by column B. In Sheet2 I set up a table. Sheet2!B3 has the formula =Sheet1!B3, and this is dragged across to fill Sheet2!B3:G3. Sheet2!B4 has this formula: =LARGE(Sheet1!$B$4:$B$2003,ROW()-ROW($B$3)) This is copied and pasted into Sheet2!B4:B2003. This sorts the column in descending order. Sheet2!A4 has this formula: =INDEX(Sheet1!A$4:A$2003,MATCH($B4,Sheet1!$B$4:$B$ 2003,0)) This is copied and pasted into Sheet2!A4:A2003 and Sheet2!C4:G2003 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... Thank you John, I appreciate the response; I have not used =large before and have looked at help on the function; however, I'm not clear as to how you are suggesting I use it to have it do the sort?? Thanks! -- Marv Lusk Boise Corporation "Jon Peltier" wrote: Use an intermediate range for the chart source which links to the real data but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart update according to high to low ranking
Thanks Jon, I appreciate the assistance; just what I needed!
-- Marv Lusk "Jon Peltier" wrote: Here's another example: http://peltiertech.com/WordPress/200...-for-charting/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message ... Here's an example. I have a table in sheet1, range A3:G2003. Column A is a set of labels, as is row 3, the data is in B4 thru G2003, and I want to sort by column B. In Sheet2 I set up a table. Sheet2!B3 has the formula =Sheet1!B3, and this is dragged across to fill Sheet2!B3:G3. Sheet2!B4 has this formula: =LARGE(Sheet1!$B$4:$B$2003,ROW()-ROW($B$3)) This is copied and pasted into Sheet2!B4:B2003. This sorts the column in descending order. Sheet2!A4 has this formula: =INDEX(Sheet1!A$4:A$2003,MATCH($B4,Sheet1!$B$4:$B$ 2003,0)) This is copied and pasted into Sheet2!A4:A2003 and Sheet2!C4:G2003 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... Thank you John, I appreciate the response; I have not used =large before and have looked at help on the function; however, I'm not clear as to how you are suggesting I use it to have it do the sort?? Thanks! -- Marv Lusk Boise Corporation "Jon Peltier" wrote: Use an intermediate range for the chart source which links to the real data but uses large() to provide the sorting. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MarvInBoise" wrote in message ... I have a chart that updates using a total line; values change daily and update the totals; I would like the chart to display left to right/high to low and I cannot sort the total/sum line to cause the chart to display this way; is there a way I can do this? It is a column chart. Thank you! -- Marv Lusk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock High-Low-Close Chart | Charts and Charting in Excel | |||
| How do I get the bars on a chart to display from low to high? | Charts and Charting in Excel | |||
| Line chart with one value extrememly high | Charts and Charting in Excel | |||
| Y Axis in a chart - high to low values | Excel Discussion (Misc queries) | |||
| 3/4 High Chart Rule | Charts and Charting in Excel | |||
Linear Mode
