Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort chart values
I have tried Jon Peltier's example on linking table to sort data for charting
by using the LARGE function, to no avail. My data is set up different than his, which I think is throwing me. Can someone help me sort the following data for the chart, but not in the data itself? Thanks. bob mary hank jo sam pam June 0 5 0 6 11 6 11-Jul 1 8 3 11 4 2 15-Jul 6 11 10 12 9 7 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sort chart values
Too hard to read the data set up. (We all need some way of showing formatted
data in newsgroup messages) Send me a sample file (to my private email) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Alex" wrote in message ... I have tried Jon Peltier's example on linking table to sort data for charting by using the LARGE function, to no avail. My data is set up different than his, which I think is throwing me. Can someone help me sort the following data for the chart, but not in the data itself? Thanks. bob mary hank jo sam pam June 0 5 0 6 11 6 11-Jul 1 8 3 11 4 2 15-Jul 6 11 10 12 9 7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Chart Values | Excel Worksheet Functions | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How do i sort values like: #103 / 4 / 23, need to sort by 2nd # | Excel Worksheet Functions | |||
Troubles with asigning x values and values to a chart | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |