If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copying values but skipping empty cells | Handyy | Worksheet Functions | 1 | February 9th, 2006 02:41 AM |
Using data from coloured cells in a chart | Mikey9131 | Worksheet Functions | 1 | November 26th, 2005 09:08 PM |
How do I remove empty chart plots from linked worksheet charts | Lee IT | Charts and Charting | 3 | January 31st, 2005 05:31 PM |
How to create stacked line chart with some empty value? | Jon Peltier | Charts and Charting | 0 | November 12th, 2003 07:35 PM |
Multiple Conditional Formats for A Chart (Please Help)? | Jon Peltier | Charts and Charting | 0 | September 19th, 2003 09:40 PM |