Bar Graph

[PAL]

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]

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


I have 6 bars i would like to graph