Variable chart Help

dall007

New Member
Joined
Mar 25, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi Everybody, first time to mrexcel. I had a question with a spreadsheet Im constructing.

I want to make a chart that changes everyday. I have inputs that are produced 2x daily. What I would like is a chart to display a price change over time without stretching the entire chart out.

Additionally I have added a condition on my dates column to clear any dates that are not after TODAY() by setting it to " " (this is to make it easier for me to input data).

My expectation is that excel should read the dates and the prices and graph them appropriately. However, it seems to mess up the x-axis. Alternatively, if I kept my dates displayed (bypassing the IF(x>TODAY()) ) then it displays a chart for the whole year, which defeats what I want the graph to do. That being, display the data x-axis to todays date.

Note: The Column with Sunday is just a marker of the start of the week, it has no interaction with the data set or the graph.
 

Attachments

  • Annotation 2020-03-25 102739.png
    Annotation 2020-03-25 102739.png
    29.6 KB · Views: 9
  • Annotation 2020-03-25 102721.png
    Annotation 2020-03-25 102721.png
    43.4 KB · Views: 9

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,126
Welcome

Hidden rows are not charted, is this solution suitable for you?

chart_sat.PNG
 

Watch MrExcel Video

Forum statistics

Threads
1,127,098
Messages
5,622,685
Members
415,920
Latest member
ExcelNoob28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top