LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 34
Default x axis info changing

I have a line chart which is plotting financial data for 3 seperate lists
withing my spreadsheet. So list A has a set of dates and dollar amounts that
correspond to those dates, list B has a different set of dates and
corresponding financial info, and the same for list C.

I need to show in the line graph all 3 lists with their corresponding dates
and financial data.

I went to the source data, series tab, and created 3 series for my 3 lists
(A, B, C). My question is how do I get the info from all 3 series to reflect
in my X axis (as it only allows me to select one set of dates). I need the
dollar amounts to be plotted on my chart with the corresponding dates, for
each individual series. The info on the Y axis is the dollar amount, the
info on the X axis are the dates.

Any help or suggestions would be greatly appreciated.
 
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
Slows Down When Changing Info within Cells Barbara Excel Discussion (Misc queries) 0 November 27th 07 08:49 PM
changing cell info Greenback Excel Discussion (Misc queries) 7 February 10th 07 05:38 PM
switch around info from legend to axis Sallie Charts and Charting in Excel 1 June 8th 06 02:59 AM
I AM TRYING TO ADD INFO TO THE CATAGORY AXIS BUT IT WONT LET ME C. CINDY Charts and Charting in Excel 2 March 23rd 05 08:18 PM
change axis info on radar charts alfred Charts and Charting in Excel 1 January 11th 05 04:36 AM


All times are GMT +1. The time now is 10:39 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"