Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have created a column chart with 4 columns with 2009 data. I want to add
overlay markers over those columns. Those markers will be the 2008 data. I have done this in the past by adding the data/xy scatter graph and so forth, but it was a long time ago and I do not remember the steps. I have tried to paste special the data to adding those columns but cannot seem to remember. Any help is appreciate. Thanks |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Copy the data for the points, select the chart, Paste Special New
Series and other relevant options. Now select the series you've added, and change the chart type to Line. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Chris wrote: I have created a column chart with 4 columns with 2009 data. I want to add overlay markers over those columns. Those markers will be the 2008 data. I have done this in the past by adding the data/xy scatter graph and so forth, but it was a long time ago and I do not remember the steps. I have tried to paste special the data to adding those columns but cannot seem to remember. Any help is appreciate. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Overlay/backgrounds | Excel Worksheet Functions | |||
Overlay bar charts | Charts and Charting in Excel | |||
Is it possible to overlay one chart on top of another | Charts and Charting in Excel | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) | |||
Overlay charts | Charts and Charting in Excel |