| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy range of cells omitting formulas that result in " "
I have a column of data that contains a formula that either returns a value
or leaves the cell blank. I would like to copy the column to another location and have the cells with no values omitted from the range. Basically, I would like to make a bar chart and have the chart adjust with changes in data. However, every empty cell is plotted as zero or blank...how can I remove these blanks from the chart? Can anyone help? I have been struggling with this for a while now...I think this is my last resort! Help! Tina |
|
#2
|
|||
|
|||
|
Select all of the data and plot it. then by using auto filter on your data
and selecting non blanks. the chart will not show zeros when plotting. "Plot only cells with values in column" wrote: I have a column of data that contains a formula that either returns a value or leaves the cell blank. I would like to copy the column to another location and have the cells with no values omitted from the range. Basically, I would like to make a bar chart and have the chart adjust with changes in data. However, every empty cell is plotted as zero or blank...how can I remove these blanks from the chart? Can anyone help? I have been struggling with this for a while now...I think this is my last resort! Help! Tina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
| Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| Amount or Numbers in Words | New Users to Excel | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
Linear Mode
