Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Representing data series as bars & lines on the same chart

Status
Not open for further replies.
beanxx

beanxx

Technical User
Jul 9, 2002
61
GB
Obviously I can represent data in a chart in a bar format or line format very easily. But how do I combine the two so that some data series are represented in a bar format but other series are represented in a line format on the SAME chart?
 
Sort by date Sort by votes
Keith,

Yes this is a slightly different question as rather than representing trends (which thanks to you I have now resolved), I want to represent a different data series. i.e. One data series is shown as a chart, whereas superimposed on this I want to also show a line graph which has the same ranges on the x and y axis?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
831
SkipVought
S
sxschech
  • Locked
  • Question
Pie Chart with linked updatable data table formatting 1
Replies
17
Views
799
combo
combo
D
  • Locked
  • Question
How can i have more than 1 line in the body of an email
Replies
2
Views
464
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
648
combo
combo
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top