Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
scatter plot problem
Basically i want to create a scatter plot using the data provided below... but i want the x axis to go by month and then have a year marker... all i can seem to get is either all the months, or all the years, but not both together... 2003 SEP $0.05453 OCT $0.05178 2003 NOV $0.05228 2003 DEC $0.05543 2004 JAN $0.05990 2004 FEB $0.06034 2004 AVG $0.05570 i only need the marker between when a year changes.. any help on how to create this scatter plot would be appreciated -- pioneermusic55 ------------------------------------------------------------------------ pioneermusic55's Profile: http://www.excelforum.com/member.php...o&userid=36756 View this thread: http://www.excelforum.com/showthread...hreadid=566095 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
scatter plot problem
This might be a good place for a line chart, which will allow you the
categories across the X axis that I think you are describing. You can double click on the series, and on the Patterns tab remove the lines between the points. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "pioneermusic55" <pioneermusic55.2bo17f_1154107209.6292@excelforu m-nospam.com wrote in message news:pioneermusic55.2bo17f_1154107209.6292@excelfo rum-nospam.com... Basically i want to create a scatter plot using the data provided below... but i want the x axis to go by month and then have a year marker... all i can seem to get is either all the months, or all the years, but not both together... 2003 SEP $0.05453 OCT $0.05178 2003 NOV $0.05228 2003 DEC $0.05543 2004 JAN $0.05990 2004 FEB $0.06034 2004 AVG $0.05570 i only need the marker between when a year changes.. any help on how to create this scatter plot would be appreciated -- pioneermusic55 ------------------------------------------------------------------------ pioneermusic55's Profile: http://www.excelforum.com/member.php...o&userid=36756 View this thread: http://www.excelforum.com/showthread...hreadid=566095 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(XY) scatter problem | Charts and Charting in Excel | |||
xy scatter plot question | Charts and Charting in Excel | |||
Scatter Plot | Charts and Charting in Excel | |||
3D Scatter plot | Excel Worksheet Functions | |||
Custom data labels on a scatter plot | Charts and Charting in Excel |