Member Avatar for SpottyBlue

Hi,

I really need help and this is my first time of trying to link 20 sheets into a survey chart (Chart 1).

How to do that? The chart in "Chart 1" is only based on sheet 1.

Excel file: https://1drv.ms/x/s!AqKGcmac7PpVz2StIkZ445NRYVat

Edited by Reverend Jim because: Moved to programming forum
  • 2 Contributors
  • 2 Replies
  • 382 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for SpottyBlue

Guys? I need help.

Member Avatar for rproffitt

My thought here is to create a sheet with the numbers from all those sheets first. That is, numbers first.

Then on that sheet create your graph. To create a graph from all those sheets directly? Not a method I'd use.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.