Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 18th 09, 01:21 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 2
Default Add multiple categories to horizontal axis in chart

Hi,
I am working on a staff sales chart & that compares 2 years worth of data on
a month by month basis for 4 staff.

I was wondering how I could have 2 categories on the horizontal axis of the
chart.
ie staff names & also month

eg Staff A Staff B Staff C Staff D Staff A Staff B Staff C Staff D
January February


Thanks in advance

  #2   Report Post  
Old April 18th 09, 08:13 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 66
Default Add multiple categories to horizontal axis in chart

The easiest way to do this is by letting Excel do "heavy lifting."

If your data are not in relational form, re-arrange them. The result should
be something like:
Month Staff_ID Sales_Value
with 1 row per salesperson-month combination.

This lets you leverage all the tools developed for use with relational tables.

Now, create a PivotTable & PivotChart with the above table as the source.

Put the Month as the 1st (outermost) row field and the Sales_ID as the 2nd
(inner) row field. Put the Sales_Value as the Data field.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Tango" wrote:

Hi,
I am working on a staff sales chart & that compares 2 years worth of data on
a month by month basis for 4 staff.

I was wondering how I could have 2 categories on the horizontal axis of the
chart.
ie staff names & also month

eg Staff A Staff B Staff C Staff D Staff A Staff B Staff C Staff D
January February


Thanks in advance



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding categories in the category axis of a chart Leo Charts and Charting in Excel 2 February 9th 08 03:28 PM
make chart with both horizontal-x axis vertical-y axis CEmery Charts and Charting in Excel 1 December 19th 07 07:11 PM
How do I get a column to appear along the horizontal axis of chart aristaeus New Users to Excel 1 March 20th 07 11:28 AM
Column Chart - X axis too thin because of MANY categories. Mike Charts and Charting in Excel 3 June 15th 06 01:18 PM
Sub-Categories for X-axis labels, line on bar chart? cfagan Charts and Charting in Excel 1 March 3rd 06 05:01 PM


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017