Chart multiple columns ?

Hi.

I have a grid/summary with (for example) 3 columns: Month, Income, Expenses.
Is there a way to plot both the income and expenses columns on the same chart ?

Was hoping to create a stacked bar chart with multiple values for each “series” . There IS a “stacked” option on the charts, but I cant figure out how to get the chart to use more than one column for the values.

[QUOTE=strahdza;18474]Hi.

I have a grid/summary with (for example) 3 columns: Month, Income, Expenses.
Is there a way to plot both the income and expenses columns on the same chart ?

Was hoping to create a stacked bar chart with multiple values for each “series” . There IS a “stacked” option on the charts, but I cant figure out how to get the chart to use more than one column for the values.[/QUOTE]

Strahdza, you can achieve this by converting Month, Income, and Expenses data into rows instead of columns. Then you can have the comparison chart, cheers, Jephta

how we would do that?