View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta[_4_] Tushar Mehta[_4_] is offline
external usenet poster
 
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