[Hidden-tech] Looking for quick Google Sheet Chart help

[David Bennett]

Hi Michael,

You should be able to exclude those two columns from your chart data
range.  If your entire series of data is in say A1:F15, and you select all
of that data, and then click Insert Chart, you can then go into the Chart
Editor Setup and change the data range(s).  You can have one range be from
A1:A15 and a second range be from D1:D:15 assuming the two columns you'd
not like to see are B:C.  Hope this helps and is what you're looking for.
Cheers.


[image: image.png]

~David Bennett
  Deerfield, MA

On Fri, May 20, 2022 at 9:24 AM Annamarie Pluhar via Hidden-discuss <
hidden-discuss at lists.hidden-tech.net> wrote:

> I have found the google community to be MOST helpful in working on
> formulas. Someone there basically set up the formulas for a community
> garden work hours system. ..
>
> Annamarie
>
> Annamarie Pluhar
> Patient, Sympathetic Coaching <http://patientsympatheticcoaching.com>
>
> On 19 May 2022, at 12:10, Michael Muller via Hidden-discuss wrote:
>
> Hey folks,
>
> I'm working on a Google sheet that tracks player statistics for an online
> game I play, and I'd like help with one particular chart. The data range is
> contiguous with the column headers, so labels aren't so hard there, but the
> Y-axis data is separated from the labels by two columns (Building and
> Donation).
>
> Here's a corner snapshot of what I'm dealing with. I'd like to chart
> columns D through AE, using row 1 as the X-axis label, and column 1 as the
> Y-axis label, leaving out columns B and C.
>
> Any help would be appreciated. I have a Zoom account and could share my
> screen if anyone here has a couple minutes to help me out.
>
> Thanks,
>
> Mik
>
> --
> Mik Muller, president
> Montague WebWorks
> 20 River Street, Greenfield, MA
> 413-320-5336http://MontagueWebWorks.com
> Powered by ROCKETFUSION
>
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
>
> http://www.hidden-tech.net/members
>
> _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
>
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20220520/c53fe740/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: XBbpoYjqX0Ukgxpx.png
Type: image/png
Size: 19664 bytes
Desc: not available
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20220520/c53fe740/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 192817 bytes
Desc: not available
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20220520/c53fe740/attachment-0003.png>