Bar Graph
in [Charts]
|
Prev: Cluster Stack Column Line Chart in Windows vs Mac
Next: Cumulative Data Labels on Stacked Bar/Column Chart
From: PAL on 1 Apr 2010 00:17 I have 6 bars i would like to graph I could get the 6 bars, but I want to separate them into two groups of three. Essentially a blank column in the graph. I would like to graph them in 2 groups of 3, Using merged cells in the headers to group the "planned" and merged cells in the headers to group the actuals. Doesn't seem to like this. make sense? ideas.
From: teylyn on 1 Apr 2010 00:41
If you lay out your data in two columns, then create a graph, they will be clustered automatically A B C 1 planned actual 2 apples 100 120 3 oranges 100 90 4 bananas 100 98 cheers, teylyn P A L ; 6 8 7 4 6 8 W r o t e : > I have 6 bars i would like to graph > > I could get the 6 bars, but I want to separate them into two groups of > three. Essentially a blank column in the graph. > > I would like to graph them in 2 groups of 3, Using merged cells in the > headers to group the "planned" and merged cells in the headers to group the > actuals. > > Doesn't seem to like this. make sense? ideas. -- teylyn Teylyn -- 'teylyn.posterous.com' (http://teylyn.posterous.com) ------------------------------------------------------------------------ teylyn's Profile: 983 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192137 http://www.thecodecage.com/forumz |