Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Line Graphs to Specific Bar Graphs | Charts and Charting in Excel | |||
Graphs in 2007 various problems | Excel Discussion (Misc queries) | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
How to macro simple graphs | Excel Programming | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |