Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2006

Tip: Looking for answers? Try searching our database.

How to Combine a Floating Column Chart with Line?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
silver23 - 09 Aug 2006 00:40 GMT
My data looks like this:
Date    B    C    D    E
06/12/06    108.95    107.64    #N/A    #N/A
06/13/06    108.38    106.67    108.61    109.29
06/14/06    108.05    108.02    108.04    108.72
06/15/06    110.15    110.04    107.71    108.39
06/16/06    110.23    109.83    109.81    110.49
06/19/06    110.29    109.02    109.89    110.57

I'm attempting to create a floating column chart using column D and E, where
the first occurrence (6/13) ought to float a column from a low of 108.61 to a
high of 109.29.  A stacked column, with the D column removed results in a
floating column from 108 to 217.  How do you produce a floating column from
108.61 to 109.29 for the 6/13 occurrence?

Then, I'd like to add a line, using column B, to the floating chart.
silver23 - 09 Aug 2006 10:36 GMT
Produce a new column containing the difference between D and E.  Then, create
a stacked column chart using Date, column D and the new (Difference) column.  
Remove the border and fill for the D series, leaving only the difference
series illustrated on the chart as floating columns.  Change date, along the
x-axis, to a category; otherwise, gaps are present for weekend days.  Adding
B as a third (line) series involves specifying the source data which renders
another stacked column, selecting the added B column series and, using chart
type, re-typing B as a line chart.  

> My data looks like this:
> Date    B    C    D    E
[quoted text clipped - 12 lines]
>
> Then, I'd like to add a line, using column B, to the floating chart.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.