LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 17
Default Line and Bar Graph in one

Hello,

I have 4 quarters per year of data and 4 years of data, a total of 16
data points, that is for the market price of an item. I have the same
number of data points for what I paid for the items.

I have the graph set up so that each quarter along the bottom has 4
bars in it (one for each year) for the market price. I then have a 4
lines (one for each year) that show what I paid for the item. So far
so good.

The problem is that where the data points are plotted (for the lines)
is in the center of, for instance, all 4 bars of Q1. (see below)
What I really want to do is have the Q1 data point for the 2005 line
be in the column of the Q1 2005 bar, not have all 4 data points for
the lines stacked in the center of the four bars.
_ _ _
_ l l xl l l l
l l l l *l l l l
l---------------------l--------------------l
Q1 Q2

Is there any way to do this while still grouping the years together by
quarter?

_ _ _
_ l*l l l l l
lXl l l l l l l
l---------------------l---------------------l
Q1

Thanks,

David

 
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
How do I make a line graph WITHOUT first line starting at zero? NorthStar Charts and Charting in Excel 9 September 7th 07 02:31 PM
Change line to bar in Line - Column graph Yonke Charts and Charting in Excel 4 January 16th 07 12:42 AM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 06:43 PM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM
Bar graph and line graph overlayed MikeR-Oz Charts and Charting in Excel 4 February 6th 06 07:01 AM


All times are GMT +1. The time now is 02:21 AM.

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

About Us

"It's about Microsoft Excel"