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
Yes
User
20/08/2018 - 08:51
A3 vs A7, et
User
20/08/2018 - 08:51
c
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
No
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
ok
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
Thx
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
Agreed
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
Thx
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
No
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
Awesome
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.