LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dan
 
Posts: n/a
Default Chart two variables with differing values

I'd like to chart data similar to:

Year 2000 2001 2002 2003 2004
Thefts 75 120 95 101
80
Veh. Mfg. 100,200 125000 130000 145000 125000

I want to produce a chart with the year on the abcissa and with the Thefts
scale on left ordinate and Veh. Mfg on the right ordinate and have the scales
set accordingly.

I'm running Excel 2002. Seems i can't select the Format/Selected Series data
Series/Secondary Axis to set the scales correctly.

I'd like to get some help on this as I think I'm missing something in my
data table, etc.
Thanks,
Dan

 
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
Zero values in a log chart Joelle_Smith Charts and Charting in Excel 2 May 8th 23 03:42 AM
Chart problem: values in column A don't show as labels on x-axis digicat Excel Discussion (Misc queries) 1 January 9th 06 07:08 PM
line chart with NA() values grime Charts and Charting in Excel 3 October 19th 05 01:56 PM
How do I eliminate duplicate values on y axis of an Excel chart? Paul Charts and Charting in Excel 1 March 24th 05 04:26 AM
Column Chart with 2 values in each column Alec Green Charts and Charting in Excel 2 February 25th 05 06:12 AM


All times are GMT +1. The time now is 09:43 AM.

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"