| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
eliminating empty cells from chart area
I have a range of 21 cells that are tracked for values on another spread
sheet at different times not all of the cells will have values this changes daily. I only want to chart the cells that have a value in that cell range but my charts keep showing the empty cells, any suggestions would be greatly appreciated |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
eliminating empty cells from chart area
Make a dynamic chart, which is based on a range which only includes
non-blank cells: http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "financeman500" wrote in message ... I have a range of 21 cells that are tracked for values on another spread sheet at different times not all of the cells will have values this changes daily. I only want to chart the cells that have a value in that cell range but my charts keep showing the empty cells, any suggestions would be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Using data from coloured cells in a chart | Excel Worksheet Functions | |||
| Ignore N/A values with an area chart | Charts and Charting in Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
