Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Slows Down When Changing Info within Cells | Excel Discussion (Misc queries) | |||
changing cell info | Excel Discussion (Misc queries) | |||
switch around info from legend to axis | Charts and Charting in Excel | |||
I AM TRYING TO ADD INFO TO THE CATAGORY AXIS BUT IT WONT LET ME C. | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel |