Excel graph, Single line to have both a negative and positive componant.

DominicJ

New Member
Joined
Sep 30, 2014
Messages
4
Sorry the title is useless.
:(

I have an accounts download with a lot of items, some debits, some credits, that are improperly hiding each other.
I have a graph based on a table based on a pivot, current out put shown below.
Orginaly, the graph was showing three columns, one of 50m one of 150 and one of 500, which isnt that hepful
I added a Cr/Dr Column, so now I get 6 columns, of -100, 150, -50, 200, 0 and 500
Which although an improvement, isnt really that clear either.

What I want, is a single column stretching from -100 to 150, another from -50 to 200, and a third from 0 to 500.
And if your method can easily replicated for the rest of the age buckets (Current, 0-30, 31-60 ect), I will be very greatful

IndustryCr/DrFuture
101Cr-100
101Dr150
102Cr-50
102Dr200
103Cr0
103Dr500

<TBODY>
</TBODY>
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

DominicJ

New Member
Joined
Sep 30, 2014
Messages
4
False Alarm, I tried selecting the second column chart type, whihc works when I just have one set of data,

So just 101 DR and 101 Cr
But it combines
102 DR/CR and 103 Dr/Cr in to it as well, which wasnt what I was after
 
Last edited:

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
5,135
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Arrange the data like this:

Code:
Industry     CR      DR
  101      -100     150
  102       -50     200
  103         0     500

Make a line chart.
Add up/down bars (using the plus icon next to the chart in Excel 2013 or the item on the Chart Tools > Layout tab in 2001-2010), which will add vertical bars that go from the CR point to the DR point for each Industry.
Format the CR and DR chart series so they use no lines and no markers.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,485
Messages
5,831,940
Members
430,096
Latest member
IBRAHEEM NAJJAR

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top