A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Graph to only include rows with data in



 
 
Thread Tools Display Modes
  #1  
Old December 9th, 2008, 02:46 PM posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
Michelle
external usenet poster
 
Posts: 82
Default Graph to only include rows with data in

Hello, I want to make a graph which is based on a table which gets its data
from other parts of my spreadsheet - so all the data is made from formulas.

Some of the rows at the bottom will be empty, and I want the graph to ignore
these empty rows, but to include them if data is added at a later date.

Is there a way to point the graph to an area, but to tell the graph to
ignore any rows where the formulas return a blank (or Icould make it zeros
if that helps). I don't want acres of graph with no columns in either, so it
would have to adjust automatically.

I'm OKish with VBA, but I'd prefer a solution that didn't use it if that's
possible.

Thanks

Michelle

  #2  
Old December 9th, 2008, 03:18 PM posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
Office_Novice
external usenet poster
 
Posts: 8
Default Graph to only include rows with data in

Have a look here

http://spreadsheetpage.com/index.php...n_a_line_chart


"Michelle" wrote:

Hello, I want to make a graph which is based on a table which gets its data
from other parts of my spreadsheet - so all the data is made from formulas.

Some of the rows at the bottom will be empty, and I want the graph to ignore
these empty rows, but to include them if data is added at a later date.

Is there a way to point the graph to an area, but to tell the graph to
ignore any rows where the formulas return a blank (or Icould make it zeros
if that helps). I don't want acres of graph with no columns in either, so it
would have to adjust automatically.

I'm OKish with VBA, but I'd prefer a solution that didn't use it if that's
possible.

Thanks

Michelle

  #3  
Old December 9th, 2008, 03:21 PM posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
Pete_UK
external usenet poster
 
Posts: 8,780
Default Graph to only include rows with data in

You could use autofilter to display Non-blanks (or Custom | Not Equal
To | 0 (zero) if you return zero in your formulae), and the graph will
adjust automatically. This is not dynamic, though - you would have to
re-apply the filter if your data changed.

Hope this helps.

Pete

On Dec 9, 1:46*pm, "Michelle" wrote:
Hello, I want to make a graph which is based on a table which gets its data
from other parts of my spreadsheet - so all the data is made from formulas.

Some of the rows at the bottom will be empty, and I want the graph to ignore
these empty rows, but to include them if data is added at a later date.

Is there a way to point the graph to an area, but to tell the graph to
ignore any rows where the formulas return a blank (or Icould make it zeros
if that helps). I don't want acres of graph with no columns in either, so it
would have to adjust automatically.

I'm OKish with VBA, but I'd prefer a solution that didn't use it if that's
possible.

Thanks

Michelle


  #4  
Old December 9th, 2008, 05:21 PM posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
Herbert Seidenberg
external usenet poster
 
Posts: 1,113
Default Graph to only include rows with data in

Excel 2007
Variable X-axis length with available data.
Dynamic, adjusts automatically.
No VBA.
Method will vary with chart and data type.
http://www.mediafire.com/file/yjdgkjynhwt/12_09_08.xlsx
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.