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! -- Heydilbert ------------------------------------------------------------------------ Heydilbert's Profile: http://www.excelforum.com/member.php...o&userid=28748 View this thread: http://www.excelforum.com/showthread...hreadid=484409 |
#2
|
|||
|
|||
Conditional Chart/Graph?
Jon Peltier has instructions for a dynamic chart:
http://www.peltiertech.com/Excel/Cha...micLast12.html 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! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Chart/Graph? | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |