Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent help on plotting a X,Y graph... | Excel Programming | |||
Help! Plotting to scatter graph | Excel Programming | |||
Plotting a Graph | Excel Discussion (Misc queries) | |||
Plotting Line Graph of Dynamic Data | Charts and Charting in Excel | |||
Graph plotting | Excel Programming |