| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination Chart Problem
Hi,
I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
Do you have categories as well? Or would an XY chart, with Qty as X and
Price as Y suffice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi, I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
Yes, the column headings are dates (years).
-- Thanks! Dee "Jon Peltier" wrote: Do you have categories as well? Or would an XY chart, with Qty as X and Price as Y suffice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi, I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
Create your chart, with series in rows, so that years appear on the
horizontal axis. I'd say a line chart is probably best. Double click one series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Yes, the column headings are dates (years). -- Thanks! Dee "Jon Peltier" wrote: Do you have categories as well? Or would an XY chart, with Qty as X and Price as Y suffice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi, I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
Hi Jon,
Thanks for your help. I tried this, but it doesn't seem to do what I am trying to do, unless I misunderstood you. Let's say I have Jan, Feb, Mar, Apr, etc. as the column headings Then I have, say row 2 that contains: $10,000 $45,000 $50,000 $18,000 and row 3 that contains: 55 65 73 20 I would like one axis to show the amounts on row 2 - no problem there. I would like the secondary axis to show the values on row 3, but... I want them directly opposite the values. So, the $10,000 would have a tick directly opposite it on the value axis that marks 55... Thanks! -- Thanks! Dee "Jon Peltier" wrote: Create your chart, with series in rows, so that years appear on the horizontal axis. I'd say a line chart is probably best. Double click one series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Yes, the column headings are dates (years). -- Thanks! Dee "Jon Peltier" wrote: Do you have categories as well? Or would an XY chart, with Qty as X and Price as Y suffice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi, I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
But then it's not an axis on the right, since the row 3 values are not
proportional to the row 2 values. For example, 18000 10000 (row 2, columns 1 and 4), but 20 < 55 (row 3, same columns). This is what Del pointed out in his post. It would be less confusing to add the row 3 values as data labels to the row 2 points. Use one of these free utilities to handle this: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi Jon, Thanks for your help. I tried this, but it doesn't seem to do what I am trying to do, unless I misunderstood you. Let's say I have Jan, Feb, Mar, Apr, etc. as the column headings Then I have, say row 2 that contains: $10,000 $45,000 $50,000 $18,000 and row 3 that contains: 55 65 73 20 I would like one axis to show the amounts on row 2 - no problem there. I would like the secondary axis to show the values on row 3, but... I want them directly opposite the values. So, the $10,000 would have a tick directly opposite it on the value axis that marks 55... Thanks! -- Thanks! Dee "Jon Peltier" wrote: Create your chart, with series in rows, so that years appear on the horizontal axis. I'd say a line chart is probably best. Double click one series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Yes, the column headings are dates (years). -- Thanks! Dee "Jon Peltier" wrote: Do you have categories as well? Or would an XY chart, with Qty as X and Price as Y suffice? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "dee" wrote in message ... Hi, I'm not sure if this is possible, but I would like to create a combination chart the has one axis correspond to the other: For argument's sake, let's say I buy veggies at a particular price and want a chart to reflect the price and the amount purchased: Qty in lbs. 100 300 200 Price .5 1 2 I want the chart to have a marker for each of the Qty values, but the second axis displaying the Price values directly opposite the corresponding Qty value. Any help would be appreciated! -- Thanks! Dee |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination Chart Problem
On Mon, 27 Aug 2007, in microsoft.public.excel.charting,
dee said: "Jon Peltier" wrote: Do you have categories as well? Or would an XY chart, with Qty as X and Price as Y suffice? Yes, the column headings are dates (years). With two independent variables each against year, you need two lines, one for price against year and one for quantity against year; then you can use two y axes. Matching the axes so that you only use one line would require the two variables to be linearly dependent, as for instance when plotting temperature, when you can have an axis for Centigrade and Fahrenheit. You can still follow the XY chart solution, if you label the data points with their year, either manually or using one of the free add-ins available. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination of stock chart and line chart | Charts and Charting in Excel | |||
| Combination Chart Problem | Charts and Charting in Excel | |||
| Combination of Validation List and VLOOKUP Problem | Excel Worksheet Functions | |||
| How to lock combination chart in pivot chart? | Charts and Charting in Excel | |||
| Combination bar and line problem | Charts and Charting in Excel | |||
Hybrid Mode
