Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

How do I create a 3-D column chart in reverse? Meaning I know what I want it to look like and show, but don't know how to start with data first
Solved by G. E. in 59 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/08/2018 - 08:40
Hi…Welcome to Got It Pro
User 20/08/2018 - 08:40
What I mean is that I do not know how to put the data so that my table turns out how I visualize it
Excelchat Expert 20/08/2018 - 08:40
Can you share the raw data and an image of how you want your chart to look like?
User 20/08/2018 - 08:41
One sec
User 20/08/2018 - 08:42
I need to visually compare income from his accounts individually with a grand total against income from my recommendations with a grand total
User 20/08/2018 - 08:48
There's the data
Excelchat Expert 20/08/2018 - 08:49
Please tell me which are the data points that you want to plot from this data.
User 20/08/2018 - 08:49
All of the dollar amounts
User 20/08/2018 - 08:50
Really everything, because I want the labels too
Excelchat Expert 20/08/2018 - 08:50
And you want comparison of each head, is that correct?
User 20/08/2018 - 08:50
User 20/08/2018 - 08:51
A3 vs A7, et
User 20/08/2018 - 08:51
Excelchat Expert 20/08/2018 - 08:51
ok..let me create the graph for you
Excelchat Expert 20/08/2018 - 08:54
Is there a specific reason you want only 3D column chart?
User 20/08/2018 - 08:54
User 20/08/2018 - 08:54
I don't need that
User 20/08/2018 - 08:54
Whatever you think is best
Excelchat Expert 20/08/2018 - 08:54
Excelchat Expert 20/08/2018 - 09:02
Are you looking at the chart I just created?
User 20/08/2018 - 09:03
Yes, does not look like what I had in mind
User 20/08/2018 - 09:03
But getting there
Excelchat Expert 20/08/2018 - 09:03
If we include Totals, the other columns shrinks because Totals has a much higher value.
Excelchat Expert 20/08/2018 - 09:04
We can also do all Current on one side and Proposed on the other. But since you said you needed to compare I did this.
User 20/08/2018 - 09:04
What about 3D?
Excelchat Expert 20/08/2018 - 09:05
Let me send you in excel as this is missing 3D chart.
User 20/08/2018 - 09:06
Excelchat Expert 20/08/2018 - 09:08
[Uploaded an Excel file]
Excelchat Expert 20/08/2018 - 09:09
3D chart doesn't look suitable though for this data.
User 20/08/2018 - 09:09
User 20/08/2018 - 09:10
Any ideas?
Excelchat Expert 20/08/2018 - 09:11
Normal column chart looks good.
Excelchat Expert 20/08/2018 - 09:12
But if we remove the Totals series, it will look more appealing
Excelchat Expert 20/08/2018 - 09:12
Let me send you 2 versions and you can check them out.
User 20/08/2018 - 09:12
Excelchat Expert 20/08/2018 - 09:13
[Uploaded an Excel file]
Excelchat Expert 20/08/2018 - 09:13
The one on the right is without the Totals.
Excelchat Expert 20/08/2018 - 09:14
Does that work?
User 20/08/2018 - 09:15
Is it possible to make each column have two colors?
User 20/08/2018 - 09:16
For example, on the ordinary income blue column, could that one column be separated into two types of money (before-tax) and (after-tax) and be separated with two different colors?
Excelchat Expert 20/08/2018 - 09:16
Are you saying you want one column to represent Current and proposed?
User 20/08/2018 - 09:17
Excelchat Expert 20/08/2018 - 09:17
No, that is not possible.
User 20/08/2018 - 09:18
3-D stacked column
Excelchat Expert 20/08/2018 - 09:18
The chart that you are referring is Stacked column and if we do that the Current & Proposed will not stay separate.
Excelchat Expert 20/08/2018 - 09:20
Please see the chart in google sheet.
Excelchat Expert 20/08/2018 - 09:20
That's a 3D stacked column.
User 20/08/2018 - 09:21
What was the other column called? Where it had proposed/current seperate?
User 20/08/2018 - 09:21
And it's impossible to do both at the same time?
Excelchat Expert 20/08/2018 - 09:21
clustered column
Excelchat Expert 20/08/2018 - 09:22
In one chart, we cannot have this 2 chart types.
User 20/08/2018 - 09:23
Is it possible to make the numbers on the left (100000, 200000, 300000, etc.) have dollar signs?
User 20/08/2018 - 09:24
So it would look like $100,000 $200,000 $300,000 etc.
User 20/08/2018 - 09:24
Excelchat Expert 20/08/2018 - 09:25
Is there anything else I can help you with this query?
User 20/08/2018 - 09:26
Do we have flexibility with the stacked columns? For instance can we have Ordinary Income, with before tax/after tax. And then have Capital Gains, with regular/pref?
User 20/08/2018 - 09:26
Does that make sense?
User 20/08/2018 - 09:27
And is there any way to change the thickness of the columns?
Excelchat Expert 20/08/2018 - 09:28
Thickness can be changed.
User 20/08/2018 - 09:28
How is that done?
Excelchat Expert 20/08/2018 - 09:31
Here is google sheet its at the optimal thickness so we can't change.
User 20/08/2018 - 09:32
Can you give me a download link for what's on the google sheet?
User 20/08/2018 - 09:32
For excel.
Excelchat Expert 20/08/2018 - 09:32
But in excel, you can right click on the column and Format data series, then under Series options you can increase or decrease the gap width
Excelchat Expert 20/08/2018 - 09:33
Please go to File > Download As > MS excel
User 20/08/2018 - 09:34
Thanks. Also, how would I add more categories? I.e. another color.
Excelchat Expert 20/08/2018 - 09:35
Again right click on the chart, Select Data and then you can add series by selecting the appropriate data range.
Excelchat Expert 20/08/2018 - 09:35
You can see those now when you do Select data, similarly you can select the additional series.
User 20/08/2018 - 09:36
So could I add 2 more series, and have certain columns only have the old two (proposed proj. & current proj.) and have some columns with the new ones?
Excelchat Expert 20/08/2018 - 09:37
Yes, you can.
User 20/08/2018 - 09:38
With ordinary income, it shows a red at the top of the column even though it shows $0 data. Why is that?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc