• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Updating Graphs with Formulated fields

X

xtr3m3dud3

New Member
Hey guys, I am working on a dashboard in which I need a graph - the source data for this graph will be certain formulated fields and fields which are blank are shown as "--".


Problem - When I make the graph, it is also considering the formulated fields and showing blank fields in the graph and this is what I DO NOT WANT. I am using Excel 2003 and not at all familiar with the vba coding.


Can someone please help me in achieving this........If I can share the spreadsheet with you for a better understanding then please let me know how to do it over here.....
 
Hi ,


This forum does not have a provision for either uploading files or attaching files to posts.


What you can do is to use your preferred file-sharing website ( RapidShare , Hotfile , DropBox , SkyDrive , GoogleDocs , SpeedyShare ... ) to upload your file , give others permission to access and download the file , and then post that access link here , in this same topic.


Narayan
 
Xtr3m3dud3


When setting up a chart if you want gaps in the data use a function like na() instead of --

eg: =If(A3>0,A3,NA())


Na() forces excel to display a #N/A error

The error allows the chart to have a gap in it


Upload files refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hui, thanks for your reply....but the gaps are what I don't want to show up in my graph, I want to show only the data part and not the N/As. The N/As will always pop up at the bottom of my data range-I don't want to manually adjust the range of the graphs every time the data changes.......is it possible?
 
I'd recommend posting a sample file as per the link in my previous post
 
Have a look at the technique Luke describes here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/
 
Hi,

You may also want to check out the following post:

http://chandoo.org/forums/topic/charting-only-select-cells-based-on-value-from-other-column


It discusses some techniques for calculating your data range dynamically.


Cheers,

Sajan.
 
You must log in or register to reply here.
Back
Top