What I want is very simple but I confess I have no idea how to do it despite googling. I think the newer table wizard is just not getting through my rapidly aging brain.
I'm editing my novel and I want to keep track of my progress to keep motivated.
I have a very simple table with dates on A and my progress in terms of pages edited in total in B and as a percent of the total page count in D.
All i really want is a simple line chart with the dates on the horizontal axis and two scales on the vertical axis, one showing total pages edited (B) and one showing percent edited (D), with a red line at the 100 mark to show me making progress for D.
The attached excel shows those values.
If two scales on the vertical are not possible then it's really just column D that's the most important.
Bookmarks