Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Sometimes I like to use a line chart, because its date scale axis is better
than what I can get from an XY chart's value axis. What I do for multiple series is create the line chart with the first series, then add the other series, and change them to XY series. The XY series will share the line chart's axis but not the X values of the first series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Del Cotter" wrote in message ... On Fri, 18 Apr 2008, in microsoft.public.excel.charting, Alicia said: 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). Abandon the line chart and use a scatter chart instead. Forget the fact that the default scatter chart has points and no lines, and a line chart has lines. You can easily give the scatter chart series lines too. -- 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 | |
|
|
![]() |
||||
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 |