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
|
|||
|
|||
Chart Issue - Excel 2003
Hello,
I have a chart that I need to build that uses a second category axis. I need to plot the following data in the following order: Actual Annual Premium Budget Annual Premium Actual Sales Budget Sales Actual Premium Collected Budget Premium Collected The actual and budget data is listed in 2 different tabs, with 12 columns - one for each month. The Primary axis is the monetary value; the secondary axis is the volume. I need to show the data in the order listed above but no matter what order I place the data into the chart, I can't get the bars to run in this order. I have tried adjusting the overlap and gap widths but that hasn't worked either. Any ideas? Many thanks. Chris |
#2
|
|||
|
|||
Chart Issue - Excel 2003
Excel has some internal rules regarding order of data in a chart legend.
Legend entries are grouped by axis and also by chart type. - Jon ------- Jon Peltier Peltier Technical Services, Inc. 774-275-0064 http://peltiertech.com/ On 3/2/2010 11:56 AM, Chris Stammers wrote: Hello, I have a chart that I need to build that uses a second category axis. I need to plot the following data in the following order: Actual Annual Premium Budget Annual Premium Actual Sales Budget Sales Actual Premium Collected Budget Premium Collected The actual and budget data is listed in 2 different tabs, with 12 columns - one for each month. The Primary axis is the monetary value; the secondary axis is the volume. I need to show the data in the order listed above but no matter what order I place the data into the chart, I can't get the bars to run in this order. I have tried adjusting the overlap and gap widths but that hasn't worked either. Any ideas? Many thanks. Chris |
#3
|
|||
|
|||
Chart Issue - Excel 2003
Thanks for your reply, Jon.
"Jon Peltier" wrote: Excel has some internal rules regarding order of data in a chart legend. Legend entries are grouped by axis and also by chart type. - Jon ------- Jon Peltier Peltier Technical Services, Inc. 774-275-0064 http://peltiertech.com/ On 3/2/2010 11:56 AM, Chris Stammers wrote: Hello, I have a chart that I need to build that uses a second category axis. I need to plot the following data in the following order: Actual Annual Premium Budget Annual Premium Actual Sales Budget Sales Actual Premium Collected Budget Premium Collected The actual and budget data is listed in 2 different tabs, with 12 columns - one for each month. The Primary axis is the monetary value; the secondary axis is the volume. I need to show the data in the order listed above but no matter what order I place the data into the chart, I can't get the bars to run in this order. I have tried adjusting the overlap and gap widths but that hasn't worked either. Any ideas? Many thanks. Chris . |
Thread Tools | |
Display Modes | |
|
|