How do you change this Excel Chart "shot numbers"

View unanswered posts | View active topics

Board index » Main Forum » General Airgun Chat

All times are UTC - 5 hours

The Canadian Airgun Forums are a place for people to discuss and learn about airguns and the airgunning sport in Canada. There are lots of discussions about airguns, airgun accessories, reviews, modification and repair information, airgun events, field target and free classifieds!

You need to register before you can post: click the register link to proceed. Before you register, please read the forum rules. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own pictures, and access many other special features. Registration is fast, simple, and absolutely free! To start viewing messages, select the forum that you want to visit from the selection below.

How do you change this Excel Chart "shot numbers"

Page 1 of 2

[ 19 posts ]

Go to page 1, 2 Next

Print view

Previous topic | Next topic

Author

Message

Canadianguy

Post subject: How do you change this Excel Chart "shot numbers"

Posted: Mon Jun 12, 2017 4:05 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

Don't really have any experience at this...Iv'e been trying off and on all day....very frustrating.

Just want to change the shot count at the bottom of chart from 1 -96 to 1-30!! That's it...

Anyone help would be appreciated??

Thanks

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

rsterne

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Mon Jun 12, 2017 6:20 pm

Joined: Sat Nov 03, 2007 4:19 pm
Posts: 9518
Location: Coalmont BC

You should be able to right-click on the horizontal axis, open the "Format Axis" menu and change it there....

Bob

_________________
Dominion Marksman Silver Shield - 5890 x 6000 in 1976, and downhill ever since!
Airsonal; Too many! Springers, Pumpers, CO2, but I love my PCPs and developing them!
Proud Member of the 2000+fps Club!

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Mon Jun 12, 2017 7:37 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

That's what I found but those bottom horizontal numbers seemed to be locked or something. I changed the fps numbers fine. I don't know how this works.

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Watertown

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Mon Jun 12, 2017 9:11 pm

Joined: Wed Feb 17, 2010 6:04 pm
Posts: 841
Location: Nova Scotia

Perhaps if you attached the spreadsheet file instead of a screen shot someone could examine the spreadsheet on their computer to see what is happening. Good luck, sometimes little things can be frustrating.

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Mon Jun 12, 2017 9:22 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

I don't know how? That would be the way to do it. Any ideas?

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Tue Jun 13, 2017 10:41 am

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

It says that this file is not allowed....i'll keep trying! Maybe I can convert it to another format.

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

AirForceAddict

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Tue Jun 13, 2017 11:25 am

Joined: Sat Apr 23, 2011 10:13 pm
Posts: 201

Just add a file extension that is acceptable after the excell extension. Excell.xml.pdf for example.

If i remember right, you should be able to just highlight the data you want to chart and it will allow you to label each axis as you wish. Been a while since i used excel though.

Sent from my SGH-I747M using Tapatalk

_________________
Don't take life too serious... It's not like you're gonna make it out alive.

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Tue Jun 13, 2017 11:32 am

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

This is the axis box I pulled up. But nothing changes I did the fps one no problem.

Attachments:

Untitled.jpg [ 368.5 KiB | Viewed 1186 times ]

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

rsterne

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Tue Jun 13, 2017 5:07 pm

Joined: Sat Nov 03, 2007 4:19 pm
Posts: 9518
Location: Coalmont BC

Only other thing I can suggest is to right click on the graph, choose "Select Data", and then edit the data string that is being graphed to shorten the number of cells being displayed.... Highlight the function name, click "Edit", and then on the new screen, shorten the "Series values" to only include the cells with data....

Bob

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Tue Jun 13, 2017 5:15 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

Thanks Bob!.....i'll give it a try!

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Mtl_Biker

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Wed Jun 14, 2017 9:39 am

Joined: Fri Dec 04, 2015 4:15 pm
Posts: 313
Location: Montreal, Quebec

Where did you get the spreadsheet? If you could supply a link, I'll download a copy and figure out what you need to change. It's possible that you're trying to change a cell (or cells) containing calculated formulas which the author may have locked to prevent accidental changes. If so, that's pretty easy to unlock but it would sort of suggest that you should be changing data in different, unlocked cells NOT containing calculations.

_________________
AA S510 Xtra FAC Ultimate Sporter *CARBINE* .22
CZ200S "Green" .177
Feinwerkbau 800 Evolution Top
Air Arms S400 MPR FT .177
Steyr EVO 10
Benjamin Sheridan 397P
Stoeger X5 (non-PAL)
Crosman P1377 & P1322

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Wed Jun 14, 2017 9:47 am

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

Hi. ...could I send you a email with the file. I got it on GTA Forum long ago.

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Mtl_Biker

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Wed Jun 14, 2017 11:37 am

Joined: Fri Dec 04, 2015 4:15 pm
Posts: 313
Location: Montreal, Quebec

Canadianguy wrote:

Hi. ...could I send you a email with the file. I got it on GTA Forum long ago.

I'm a member of GTA... If you could tell me where to find it and get it, I'll do that and try to help you out.

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Wed Jun 14, 2017 12:02 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

I'm trying to look I can't find it anywhere!

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Canadianguy

Post subject: Re: How do you change this Excel Chart "shot numbers"

Posted: Wed Jun 14, 2017 3:02 pm

Joined: Tue Mar 12, 2013 1:35 pm
Posts: 1154
Location: North Of Toronto

I can't believe I found it!....here is the link.....His name is Shorty in a zip file.

http://www.gatewaytoairguns.org/GTA/ind ... #msg962054

_________________
Benjamin Discovery .22
Crosman DPMS SBR .BB
Crosman 2240 HPA .22
S&W M29 8 3/8" Pellet
Dan Wesson 715 Nickel 6" Pellet
Sig Sauer M17 Pellet
KWC 1911 Tac .BB
Leapers UTG BB 3x12x32

Top

Page 1 of 2

[ 19 posts ]

Go to page 1, 2 Next

Board index » Main Forum » General Airgun Chat

All times are UTC - 5 hours

Who is online

Users browsing this forum: No registered users and 10 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum