dynamic range in chart


I have defined two ranges with the names: datePnL and DailyPnL

and formulas:


I am having a problem inputting the ranges correctly into the series bar of a chart. I have included a worksheet as an example. Can you either create a bar chart for me or instruct me on how to do it. I have tried and even got the PnL column to work but not the date column and therefore the chart would not update dynamically.
Who is Participating?
byundtConnect With a Mentor Commented:
Change your named range definitions to:

Click on the series in the chart, then modify the formula in the formula bar to:
There are other constructions possible for your named range definitions:
=DailyPnL!$H$4:INDEX(DailyPnL!$H$4:$H$1000,COUNT(DailyPnL!$H$4:$H$1000))      'My favorite because it is not volatile

You need to enclose the name of the workbook in single quotes when using the named range in your series definitions. Excel requires either the Sheet name or Workbook name preceding the named range name.
CC10Author Commented:
Thanks very much
All Courses

From novice to tech pro — start learning today.