Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Newsman
 
Posts: n/a
Default Can't quite get what I want with bar chart; help appreciated

I have 3 columns of data: (1) product name; (2) date of production; and
(3) quantity produced. The data is arranged in rows. In other words,
each row corresponds to a particular product. Also note that not all
production dates are unique.

I would like to create a bar chart with one bar for each product. The
date of production should be on the x-axis, quantity produced on the
y-axis, and the product names as the legend text. But I can't quite seem
to get it right. I've got 23 nicely colored bars and the product names
as the legend text. But I can't get the dates on the x-axis.

It seems like I might need to somehow fool Excel into doing what I want.
But I don't know how to get it done. Any help you can provide would be
much appreciated.

Thanks,
Rich
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
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Pie chart on a pie chart (exploded)? KR Excel Discussion (Misc queries) 1 June 9th 05 07:28 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 06:08 PM.

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

About Us

"It's about Microsoft Excel"