Hi everyone.
Is it possible to display only the 2 lines in the graph?
Now there are 2 rows for the data and 3 empty rows.
Only 2 series of columns must be present in the graph.
I hope to be explained to me.
max
Hi everyone.
Is it possible to display only the 2 lines in the graph?
Now there are 2 rows for the data and 3 empty rows.
Only 2 series of columns must be present in the graph.
I hope to be explained to me.
max
Last edited by max_max; 07-14-2020 at 04:17 PM.
Hi,
I'm not sure if it worked the same way in Excel 2007 (I do not have it installed any longer) but with version 2016 it is enough to use the autofilter on the data and not visible data is not used at the graph.
See attached.
Another possibility is to use the name manager to create "Dynamic graph" - see for example https://peltiertech.com/Excel/Charts...umnChart1.html
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks