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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Charts in Excel - Ending line graphs

Status
Not open for further replies.
cjackson

cjackson

Technical User
Dec 1, 2000
44
US
I am using Excel to chart actual sales against projected sales.

The data for the projected sales is fixed and produces a line graph up till the end of the month.

The data for the actual sales comes from another spreadsheet on a daily basis and also produces a line chart. At the moment the line drops to zero after the last days data but continues to the end of the month.

How can I stop the line graph for my actual sales at the last piece of data?

 
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
302
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
297
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
886
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
680
SoftwareRT
SoftwareRT

Part and Inventory Search

Sponsor

Back
Top