Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 01-04-2019, 08:19 AM
ArviLaanemets ArviLaanemets is offline Chart question Windows 8 Chart question Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Do you want the chart ignore whenever there is value = 0 (when you want this, you must be 100% sure, there never will be value 0 measured), or when there is no value (i.e no measurement was made at given date, and the ProbeValue cell is empty)?

To force line graph to interpolate missing data, in source table must be "#N/A" instead of measurement for break date. E.g. in table tRep1 in column ProbeValue use formula
Code:
=IF(COUNTIFS(tData[ProbeDate],[@ProbeDate],tData[ProbePlace],nRep1Place,tData[ProbeValue],"")=1,NA(),SUMIFS(tData[ProbeValue],tData[ProbeDate],[@ProbeDate],tData[ProbePlace],nRep1Place))
instead.

The only way to have the line graph to have break instead of interpolation I found in google, was to fix it in certain non-dynamic chart.

I'm almost sure I cold make a line graph to have a break instead of interpolation in dynamic graph years ago, but I don't remember anymore how I did it, and I didn't find anything in google too. Maybe it was possible in older versions (used some 15 years ago).
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
PPT 2010 - Animated Chart by Series - Animations reset when editing chart agaudet21 PowerPoint 0 10-12-2017 06:18 AM
Chart question MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table billcary Project 3 09-22-2014 07:10 AM
Question - Chart dapaq2 Word 0 01-03-2013 01:30 AM
Chart question Newbie Question - Chart Data KarynHill PowerPoint 6 01-08-2012 07:22 AM
Outlook chart question projecttoday Outlook 0 11-11-2011 11:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft