Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 16th 14, 08:25 AM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 3
Default Problems with simple line graphs

I am presenting a simple 2d array of values in VBA (which is variable in size) and get different graph formats for the same graph style depending on the number of columns. For example, this data:

Ave Set1 Set2 Set3 ...... Set10
C1 7.5 7.0 6.0 6.5 4.0
C2 7.5 7.5 7.5 7.5 6.0
C3 7.5 8.0 9.0 8.5 5.0

which is a 2d array (C1/Ave/7.5 are one cell, C1/Set10/4.0 are another cell etc) displays a perfect line graph with the decimal values as the 'y' values, C1 to C3 as the 'x' axis and Ave, Set1 to Set10 as the Legend.

If I add a new Set, say Set11, the graph format changes so C1 to C3 become the Legend and Ave, Set1 to Set11 become the 'x' axis. Please Help!

  #2   Report Post  
Old August 18th 14, 12:17 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2014
Posts: 3
Default Problems with simple line graphs

Hi,

If I add a new Set, say Set11, the graph format changes
so C1 to C3 become the Legend and Ave, Set1 to Set11
become the 'x' axis.


how do you add the new Set? After that, do you create a new graph, or do you
just expand data range?
I think, after creating a new chart you have to switch columns/rows.

--
Cheers,
Lisa

  #3   Report Post  
Old August 18th 14, 01:10 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 3
Default

Quote:
Originally Posted by Lisa Wilke-Thissen[_2_] View Post
Hi,
[color=blue][i]

how do you add the new Set? After that, do you create a new graph, or do you
just expand data range?
I think, after creating a new chart you have to switch columns/rows.

--
Cheers,
Lisa
Thanks Lisa. The new set is created effectively from scratch being a completely different set of data from the previous array. The graph is invoked again as a fresh call to the graph. Why would we need to switch cols/rows? Do you know if the graph requires this or is this a workaround?
  #4   Report Post  
Old August 21st 14, 07:52 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2014
Posts: 3
Default Problems with simple line graphs

Hi,

The graph is invoked again as a fresh call to the graph.
Why would we need to switch cols/rows?


Ave Set1 Set2 Set3 ...... Set10
C1 7.5 7.0 6.0 6.5 4.0
C2 7.5 7.5 7.5 7.5 6.0
C3 7.5 8.0 9.0 8.5 5.0


regarding your array, in a default chart C1, C2, C3 will be the legend.
Set1, Set2 ... will be the x-axis.
Therefore, in Word 2013 you have to choose "Chart Tools | Design | Data |
Switch Row/Column" for your chard.

--
Cheers,
Lisa

  #5   Report Post  
Old August 22nd 14, 07:12 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 3
Default

Quote:
Originally Posted by Lisa Wilke-Thissen[_2_] View Post
Hi,

The graph is invoked again as a fresh call to the graph.
Why would we need to switch cols/rows?


Ave Set1 Set2 Set3 ...... Set10
C1 7.5 7.0 6.0 6.5 4.0
C2 7.5 7.5 7.5 7.5 6.0
C3 7.5 8.0 9.0 8.5 5.0


regarding your array, in a default chart C1, C2, C3 will be the legend.
Set1, Set2 ... will be the x-axis.
Therefore, in Word 2013 you have to choose "Chart Tools | Design | Data |
Switch Row/Column" for your chard.

--
Cheers,
Lisa
Brilliant - thanks very much Lisa.


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
Plotting Line Graphs to Specific Bar Graphs Elise Scoggins Charts and Charting in Excel 1 July 3rd 12 08:40 PM
Graphs in 2007 various problems blubblub Excel Discussion (Misc queries) 1 July 16th 07 02:12 PM
How do you select line or columns in "Line-Column on 2 axes" graphs? mizterbusy Excel Discussion (Misc queries) 0 September 19th 06 06:48 AM
How to macro simple graphs mikerr[_5_] Excel Programming 0 September 13th 05 07:17 PM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 07:16 PM


All times are GMT +1. The time now is 05:02 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017