How to make a chart with selective (discontinuous) data?

  • Thread starter Making grapg from discontinuous data
  • Start date
M

Making grapg from discontinuous data

For example, two colums A and B have 10 rows (2 to 11) with values in each
cell.
How can I make a graph A Vs B which displays data only from rows 2, 5 8 and
10. I mean from discontinuous data and not from a continuous range. If yes
how to do in very large sheet?
 
D

David Biddulph

Best to use your worksheet to pull the data into a continuous range, and
then plot that.
--
David Biddulph

"Making grapg from discontinuous data" <Making grapg from discontinuous
(e-mail address removed)> wrote in message
news:[email protected]...
 

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

Finding the right style field in VBA 0
Creating a Chart on form from selected data in query. 0
Finding the proper style field and the numbered paragraph value within the style 0
Need Help with a VBA subroutine 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Make a mekko chart in Excel 2007 in three easy Steps 1
Occasional meter readings chart 0
Avoiding cells being included in a chart 4

Top