#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chrisk
 
Posts: n/a
Default chart types

how can I mix a line chart and a scatter chart.
i want to plot a line of values and dots only for the corrections to the
values.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default chart types

chrisk -

I recommend that you use an XY (Scatter) chart type for both data series
(where each data series contains it own XY pairs on the worksheet). This way
you will have maximum control over the placement of the points. For each XY
series on the chart, you can format the series pattern to show markers only,
lines only, both markers and lines, or neither. For subsequent questions,
consider posting in the microsoft.public.excel.charting newsgroup.

- Mike
www.mikemiddleton.com

"chrisk" wrote in message
...
how can I mix a line chart and a scatter chart.
i want to plot a line of values and dots only for the corrections to the
values.



Reply
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
Create a combo chart with two of the same chart types Mark Parent Charts and Charting in Excel 2 October 14th 05 01:28 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 12:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"