Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Chart/Graph?
I'll try to simplify things as much as possible. I currently have a numerically ordered list. I need to only display the list up to a certain number. The certain number which I need to list up to changes depending on other variables. I also need to display this restricted list in a graph/chart. I could conditionally format the list to only display numbers in a readable font colour up to the certain number, however when i then put the data into a chart, the values which are unreadable on the worksheet (e.g. because they are the same colour as the background) are displayed in the graph. Any assistance would be appreciated! *Conditional Chart/Graph?* -- Heydilbert ------------------------------------------------------------------------ Heydilbert's Profile: http://www.excelforum.com/member.php...o&userid=28748 View this thread: http://www.excelforum.com/showthread...hreadid=484410 |
#2
|
|||
|
|||
Conditional Chart/Graph?
Option 1 Assuming your data is in column A, you could insert a start row number in B1 and a finish row number in B2 and use the formula =IF(AND($B$1<=ROW(),$B$2=ROW()),A1,"") in C1 and formula copy enough rows to match the data in column A, and then chart from Column C I don't know how to make the chart range variable to prevent the blank area at the start and end of the chart, but only required data will be displayed. Hide columns A & B if required. Option 2 same data in column A, but for a fixed number of cell display, (ie, if you always want to display only 12 items) in B1 the start row, in B2 the number of rows Set the chart to C1:C12 In C1 the formula =IF(ROW()<=B$2,OFFSET(A$1,ROW()+B$1,0),"") and formula copy down to cover the maximum number of rows that you will ever chart. Then chart from the C column. Hope this gives you some idea. Heydilbert Wrote: I'll try to simplify things as much as possible. I currently have a numerically ordered list. I need to only display the list up to a certain number. The certain number which I need to list up to changes depending on other variables. I also need to display this restricted list in a graph/chart. I could conditionally format the list to only display numbers in a readable font colour up to the certain number, however when i then put the data into a chart, the values which are unreadable on the worksheet (e.g. because they are the same colour as the background) are displayed in the graph. Any assistance would be appreciated! *Conditional Chart/Graph?* -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=484410 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |