Creating a bar chart with negative values on the left and positive values on the right

Hi all,

I am using Excel 2007. Is there a way to create a bar chart where negative values associated with a time period show up on the left, and positive values show up on the right? I have 3 columns of data (negative cashflows, date, positive cashflows), and I am trying to create a chart that graphically shows when negative cashflows occur compared to positive cashflows over a period of time. Occasionally both occur at the same date.

Many thanks!

Negative values show up to the left of the zero-axis by default.

You might have to fiddle with where your axis sits to make it look nice, but that's "just" formatting.

If you have more than one y-value for each x-value (ie, more than one dollar amount per date), then you might want to set it up as a Clustered Bar Chart.

You can change the x-axis value from the default of counting along the values to some array with Select Data > Horizontal (Category) Axis Labels > Edit > (enter array).

Thank you. In the end, I decided it was easiest to do an area chart.

Thank you for the response though, very much appreciated!