I'm trying to create a line chart in the attached Excel spreadsheet.
I want the date (Column A) on the abscissa axis and line charts for Columns B-G in a single chart.
Can someone do this for me.
I'm trying to create a line chart in the attached Excel spreadsheet.
I want the date (Column A) on the abscissa axis and line charts for Columns B-G in a single chart.
Can someone do this for me.
Please see the attached.
I've used dynamic named ranges so the chart should automatically adjust as new rows are added to the first tab. The chart is on a separate tab to give greater clarity.
Martin
mrice. Thank you so much - Exactly what I wanted.
The chart is not updating for the most recent row. Anyone please assist?
Many thanks.
The issue is caused by the blank line in line 2. If this is removed, the chart should display correctly.
Thank you very much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks