If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
bookmark a chart? | Jon Peltier | Charts and Charting | 0 | August 28th, 2005 01:23 AM |
Multiple filter query of form | truepantera | Using Forms | 6 | August 4th, 2005 08:26 AM |
chartgroups,chartobjects etc-confusion to me | R.VENKATARAMAN | Charts and Charting | 1 | April 10th, 2004 04:09 PM |
build chart template; then add series one by one | L Mehl | Charts and Charting | 2 | February 12th, 2004 10:53 PM |