Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 28th 14, 09:04 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 15
Default Plotting Graph with dynamic table

I have a dynamic table where x-axis may not have all data to be plotted.
Scenario 1:

x y
Jun 3 balls
Jul 5 balls
aug 3 balls

Scenario 2:
x y
Jun 3 balls
Jul 3 balls
Aug 3 balls
Sep 8 balls
Oct 7 balls


How can I create a graph that can dynamically plot the data without having a big blank on the right side of the graph?

As in the the data table size is fixed but not all the months data may be populated.
One scenario may be the report maybe generated for 3 months data while another report may be generated for 5 months data , while another may be for a 12 months data.

But I do not want to show blank spaces on the right when I only have 3 months data but the system plot it for 24 months period.




Please help.
Many thanks in advance

Last edited by CS Chia : March 3rd 14 at 02:24 AM Reason: Add more information

  #2   Report Post  
Old February 28th 14, 10:07 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Plotting Graph with dynamic table

Hi,

Am Fri, 28 Feb 2014 09:04:16 +0000 schrieb CS Chia:

How can I create a graph that can dynamically plot the data without
having a big blank on the right side of the graph?


please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "ChartTest"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Old March 3rd 14, 01:43 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2013
Posts: 15
Default

Quote:
Originally Posted by Claus Busch View Post
Hi,

Am Fri, 28 Feb 2014 09:04:16 +0000 schrieb CS Chia:

How can I create a graph that can dynamically plot the data without
having a big blank on the right side of the graph?


please have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "ChartTest"


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Could you share your approach?
How does the number of months field help in generating the chart?
  #4   Report Post  
Old March 3rd 14, 06:20 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,685
Default Plotting Graph with dynamic table

Hi,

Am Mon, 3 Mar 2014 01:43:22 +0000 schrieb CS Chia:

How does the number of months field help in generating the chart?


the chart will be created by a named ranges. Look into the name manager
to see how the months field changes the range.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Urgent help on plotting a X,Y graph... Mike Middleton Excel Programming 0 June 28th 07 06:30 PM
Help! Plotting to scatter graph katem[_2_] Excel Programming 7 June 18th 07 01:20 PM
Plotting a Graph Mayank Excel Discussion (Misc queries) 2 June 9th 06 08:12 PM
Plotting Line Graph of Dynamic Data sslack Charts and Charting in Excel 1 June 6th 05 03:29 AM
Graph plotting Dovla Excel Programming 0 September 9th 04 02:05 PM


All times are GMT +1. The time now is 06:19 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017