Excel Barchart: Axis title

Posted on 2011-10-07
Medium Priority
Last Modified: 2012-05-12
Please let me know how I can group columns in an excel chart and assign a name to that group

I have attached my original chart, and the desired chart.

Thanks! Chart
Question by:dshrenik
  • 3
  • 2
LVL 93

Expert Comment

by:Patrick Matthews
ID: 36933861
You cannot do this with a normal chart, but you (sort of) can with a PivotChart.

For example:

1) Put the following data into a worksheet:

G Level      Div      Prod      Color      Sales
G1      1.1      P1      Red      560
G1      1.1      P1      Green      678
G1      1.1      P1      Blue      374
G1      1.1      P2      Red      472
G1      1.1      P2      Green      607
G1      1.1      P2      Blue      649
G1      1.2      P3      Red      746
G1      1.2      P3      Green      895
G1      1.2      P3      Blue      508
G1      1.2      P4      Red      485
G1      1.2      P4      Green      283
G1      1.2      P4      Blue      123
G2      2.1      P5      Red      596
G2      2.1      P5      Green      888
G2      2.1      P5      Blue      869
G2      2.1      P6      Red      503
G2      2.1      P6      Green      664
G2      2.1      P6      Blue      738
G2      2.2      P7      Red      136
G2      2.2      P7      Green      292
G2      2.2      P7      Blue      455
G2      2.2      P8      Red      518
G2      2.2      P8      Green      874
G2      2.2      P8      Blue      523

2) Create a PivotTable based on those data, with G Level, Div, Prod, and Color as row labels, and Sum of Sales as the value field

3) Create a PivotChart based on that PivotTable

You might also want to see this article for additional PivotTable/PivotChart tips:


Author Comment

ID: 36934008
Can you show me a sample picture, as to how it might look like?

LVL 93

Accepted Solution

Patrick Matthews earned 1000 total points
ID: 36934565
Here's a sample file

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1000 total points
ID: 36935557
Not for points.

You don't need a pivot chart. Excel supports multi-level category labels in regular charts. You only populate the first instance of a new row title, then create a chart, and it will turn out just the same. See attached chart, on the Data Sheet.

cheers, teylyn

LVL 93

Expert Comment

by:Patrick Matthews
ID: 36935627

Is that a new feature from the revised chart engine that came with Excel 2007, or had it been there all along?

Never knew about that trick :)

LVL 50
ID: 36936961
Nope, works in 2003 as well, in all its ugly glory


Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question