| 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 | |||
Linear Mode
