Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Filtered data chart
Hi I am filtering data based on rank, and I would like to plot the top 5 automatically on the chart. basically these ranks and their data is all linked...so i want the chart to change as and when data changes and ranks go up or down How do i go ahead doing that? -- shrutikhurana ------------------------------------------------------------------------ shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868 View this thread: http://www.excelforum.com/showthread...hreadid=550371 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Filtered data chart
Hello:
I am not sure how you show yr ranking. If this is in random order just with a column showing the rank number, you can pick up yr data with VLOOKUP and display it in the right order (e.g. with rank 1-5). Simply link yr chart to these cells and it should work, i.e. it shd be dynamic. One remark: RANK may give similar rank numbers which could mess up your VLOOKUP. Hence, make a workaround to generate unique rank numbers. HTH, Henk "shrutikhurana" wrote: Hi I am filtering data based on rank, and I would like to plot the top 5 automatically on the chart. basically these ranks and their data is all linked...so i want the chart to change as and when data changes and ranks go up or down How do i go ahead doing that? -- shrutikhurana ------------------------------------------------------------------------ shrutikhurana's Profile: http://www.excelforum.com/member.php...o&userid=29868 View this thread: http://www.excelforum.com/showthread...hreadid=550371 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels on Filtered Data | Charts and Charting in Excel | |||
How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |