473,221 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

controling graphs and Charts

I have created a chart with present and future dates. In this chart I use a vlookup formula to look up information from a pivot table. I have also added error handling so that if a date is not in the pivot table that is on the chart if leaves the cell blank. This works great for all future dates.

However when I have created a graph from the table the data lines on the graph go to zero. this make the chart look messy.

How can I get the graph to not drop to zero for future dates but stop once it reaches the current date. I only want the graph to read the cells with results to the formula, and ignore the cells that just contain a formula or the result of the formula that equals "".
I was hoping that this could be done automatically so I don't have to go to the select data window and turn on the next future date, or have to go to the chart and select the formula and drag it to the next new date. All I want to do is Refresh the pivot table and everything else updates automatically.
Nov 16 '17 #1
2 5656
3,653 Expert Mod 2GB

AFAIK, when Excel creates a chart, zero values (0) and empty string values ("") will cause the line to go to zero on the Axis. However, a Null value will cause a break in the line (if all future dates are non-existent, then the line would simply "stop" at the last date found.

You would have to assign a Null value to such cells for the chart to behave this way.

Hope this hepps!
Jan 3 '18 #2
272 256MB
Excel Chart(Line graph) Connect Missing Data.

Right-click the chart or graph. This will display the chart options. Click the "Select Data" option.
In the Select Data Source window, click the "Hidden or Empty Cells" button at the bottom left of the window.
Click the "Connect data points with a line" radar button. Click [OK].
Dec 27 '19 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Ratnakar Pedagani | last post by:
Hi, I want to know as how to plot 3 dimensional graphs which takes 3 cordinates and plots a line in a 3 dimensional plane. is it possible to do it in visual basic? if so please help me out in...
by: dcinfinite | last post by:
hi everyone.. i have a question. is there anyway that Asp.net with vb.net is able to do/generate Graphs?charts or anything like tat?im currently creating a web based managment system, i would...
by: Erwin | last post by:
I'm working on a report. Within this report a chart (line chart) is build which shows how many suggestions have been made per servicegroupe. Now I have put such a chart into the report, but the...
by: Bruce Schechter | last post by:
I need to generate a series of line charts dynamically from ADO.NET data in an ASP.NET application. I've read several articles about using GDI+ to render graphs into a bitmap image and then to...
by: Don Wash | last post by:
Hi There! I'm using CrystalReportsViewer control in my ASP.NET page to display the report. How do I increase the image quality of charts produced by Crystal Reports ..NET report file? Many...
by: Rach | last post by:
Hi, Does anyone know how to export charts/graphs from EXCEl into Powerpoint-Microsoft Charts though VBA code. I would like to import the underlying data with the chart as well. I know we can...
by: chandra.somesh | last post by:
Hi I wanted to draw charts/graphs by reading data from System.Web.UI.WebControls.DataGrid and render it on the web page.What is the best method to achieve this? Thanks Somesh Chandra
by: impetus | last post by:
how to generat graphs/charts on a web page from database like ms access or sql
by: Heiko Niedermeyer | last post by:
Sorry for the fuzzy subject... Currently I'm writing a little programm to extract some chemical information out of a text file, and then present it in a pleasant way. The Extraction works so...
daniel aristidou
by: daniel aristidou | last post by:
Hi anyone know an apllication which can help me make loads of "Good looking Graphs" because the microsoft graph/chart control looks so "Old" You know what i mean
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.