Help with graph

[xgirl]

Hello, I am having trouble representing this data in a graph
Column A = 17 Items
Column B = September Reported
Column C = September Actual
Column D = October Reported
Column E = October Actual
.... to the end of the year
I want to show each item with the numbers reported in contrast to the acutal.
I can't get it into a format that is easily represented in a graph. Am I
arranging my data incorrectly? What kind of graph should I use?

[Bryan Hessey]

Hi,

You could create a (say Bar) chart from your data by selecting B1 and D1 (select B1, CTRL-click D1) and Insert Chart. On the Series tab, add a Series2 which is C1,E1 and complete the chart.

However, it is better practice to set the data for a chart series to be contiguous cells, then the series can be easily adjusted to include additional months.

If it is necessary that your B,C,D & E columns be preserved then you could use 'helper' cells that reflect the data but in sequence (asin the K area)

See the attached for both charts.

Hello, I am having trouble representing this data in a graph
Column A = 17 Items
Column B = September Reported
Column C = September Actual
Column D = October Reported
Column E = October Actual
.... to the end of the year
I want to show each item with the numbers reported in contrast to the acutal.
I can't get it into a format that is easily represented in a graph. Am I
arranging my data incorrectly? What kind of graph should I use?

[xgirl]

Thanks Brian that worked.

"Bryan Hessey" wrote:

>
> Hi,
>
> You could create a (say Bar) chart from your data by selecting B1 and
> D1 (select B1, CTRL-click D1) and Insert Chart. On the Series tab, add
> a Series2 which is C1,E1 and complete the chart.
>
> However, it is better practice to set the data for a chart series to be
> contiguous cells, then the series can be easily adjusted to include
> additional months.
>
> If it is necessary that your B,C,D & E columns be preserved then you
> could use 'helper' cells that reflect the data but in sequence (asin
> the K area)
>
> See the attached for both charts.
>
>
>
>
> xgirl Wrote:
> > Hello, I am having trouble representing this data in a graph
> > Column A = 17 Items
> > Column B = September Reported
> > Column C = September Actual
> > Column D = October Reported
> > Column E = October Actual
> > .... to the end of the year
> > I want to show each item with the numbers reported in contrast to the
> > acutal.
> > I can't get it into a format that is easily represented in a graph. Am
> > I
> > arranging my data incorrectly? What kind of graph should I use?
>
>
> +-------------------------------------------------------------------+
> |Filename: Book2.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3772 |
> +-------------------------------------------------------------------+
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=401341
>
>