|
| 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
March 2nd, 2010, 04:56 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
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
March 2nd, 2010, 05:38 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
March 3rd, 2010, 11:18 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 | |
|
|
Linear Mode
