Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi,
I'm now trying to do a source of infomation for a series line on a line graph. Thing is, I need it to miss out one of the cells in its calculation. How can I go about doing this? |
#2
![]() |
|||
|
|||
![]()
I am not sure what you are asking for.
if you want a blank spot in the chart for a no data point got to <tools<options<chart and select not plotted for enpty cells. If you want something Else, more description please. "Wilkesy50" wrote: Hi, I'm now trying to do a source of infomation for a series line on a line graph. Thing is, I need it to miss out one of the cells in its calculation. How can I go about doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |