=VG= BLuDKLoT Posted October 15, 2021 at 04:29 PM Report Share Posted October 15, 2021 at 04:29 PM Hey guys, I'm trying to make a graph in excel but only 2 data cells out of 4 are graphing and I can't figure out the axis stuff, never tried this before, lol. Watched some vids, but still isn't working, I'm getting stressed. Anyone out there with mastery in excel? Please help! I can send you file. Thanks Blud. Quote Link to comment Share on other sites More sharing options...
=VG= SemlerPDX Posted October 15, 2021 at 06:14 PM Report Share Posted October 15, 2021 at 06:14 PM I'm proficient with Excel, but the edition I use is SBE 2003 (as old as it sounds). But not sure how much has changed - you create your data cells, select them all, select Insert Chart, and follow prompts in the Chart Wizard to complete and insert into the existing sheet, or a new sheet in the file. I know this may not translate 100%, but I'm gonna try anyway and hope for the best... if anyone else has better/more modern step-by-step flow, please post up here!*TLDNR; This is a method from my Excel version from 2003 and may not be 100% applicable to a modern version, BUT this flow should be quite similar if MS still has the Chart Wizard in some form. Hope this helps - but it may not translate properly to the version you are using - had to try anyway. Set some data in cells: Select all cells including row/column labels: With these cells highlighted as selection, select Insert > Chart... Assuming the Chart Wizard still exists in the version you are using, select options for type of chart: Select the range of the chart in Rows or Columns, can set series here as well if applicable: Next, the Wizard should allow options for the look and appearance - set Title and Category/Value Labels and other options here: Choose the destination for this chart, either as a New Sheet or as object in existing sheet (just click Finish): Final Product should be a chart object with resize options and linked to all 4 data cells selected in step 2: 1 Quote Link to comment Share on other sites More sharing options...
=VG= BLuDKLoT Posted October 15, 2021 at 06:19 PM Author Report Share Posted October 15, 2021 at 06:19 PM IK sent you file needs to be line chart but I think your version too old Quote Link to comment Share on other sites More sharing options...
=VG= SemlerPDX Posted October 15, 2021 at 06:24 PM Report Share Posted October 15, 2021 at 06:24 PM 3 minutes ago, =VG= BLuDKLoT said: IK sent you file needs to be line chart but I think your version too old Yeah, I just tried right now to see if MS would allow me to install a trial version of latest Excel, but they want money and I don't have it. (One reason I've kept using my 2003 edition so long - hadn't needed anything more, and didn't want to give MS more money when what I had already worked well enough) Quote Link to comment Share on other sites More sharing options...
=VG= BLuDKLoT Posted October 15, 2021 at 08:43 PM Author Report Share Posted October 15, 2021 at 08:43 PM ya i pay like 6.99 monthly for full ms office but I only use word and ppt lol. Quote Link to comment Share on other sites More sharing options...
=VG= Kavelenko Posted October 15, 2021 at 09:44 PM Report Share Posted October 15, 2021 at 09:44 PM https://support.microsoft.com/en-us/office/video-create-pie-bar-and-line-charts-ce4beacc-7e25-4574-a8b9-a865dbb3e3d2 There's some basic tutorials built in to MS Office 365 for how to do them but this video might be easier to follow: 2 Quote Link to comment Share on other sites More sharing options...
=VG= BLuDKLoT Posted October 16, 2021 at 01:02 AM Author Report Share Posted October 16, 2021 at 01:02 AM I made a new one like that vid and it worked thanks kav 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.