Excel: 20 rows but need to display only 2 at a time in a chart.

R

Roshlin

Hi friends,

I have a chart with 20 rows and columns. I need to compare 2 rows at a time
in a simple line chart to see thier progress, for example row 1 with row 5 ,
then 4 with 10 and then 1 with 16 etc.

what would be the easiest way to achive this, for now I have to do it by
selecting the rows each time by edit data.

Can I have 2 dropdown menus above the chart with the column names so that
the chart would display the values I chose.

Thanks for your help.
Roshlin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

20 rows but need to display only 2 at a time in a chart. 6
How to getting text labels to show up in scatter chart. 0
Indenting every other paragraph in Word at the same time? 0
Cannot bring rows to Height 1 in Print view 0
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
create chart with column axis 10
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top