Hay, Excel Masters!

[89th]

@George-K get it figured out? It depends if you want the 2nd set of data to be in the same line as the first, or if you want two lines.

[George K]

@89th said in Hay, Excel Masters!:

@George-K get it figured out?

Not yet. I want the second data set to extend the line of the first.

IOW, I want all the dates on the x-axis and the numbers on the y-axis.

[Horace]

I would just copy the last pair of columns at the bottom of the first pair of columns. But I guess the problem isn't as simple as the example you provided.

[George K]

@Horace said in Hay, Excel Masters!:

I would just copy the last pair of columns at the bottom of the first pair of columns. But I guess the problem isn't as simple as the example you provided.

That's the obvious, simple, solution. However, the actual sheet I'm working on has data that I want to keep visible below the first two columns. Hence the need for the 2nd column.

[Horace]

you could also make formulas in a hidden away part of the sheet where cell J2 is "=A2", copy that down to J8, then J9 is "=D2", copy that down to J15. Similar for the other column of data, then build your charts from your out-of-the-way columns

[89th]

It would help to know what these values represent. Views of TNCR? Trips to the liquor store?

[Horace]

I think it's where he keeps his passwords.

[George K]

@89th said in Hay, Excel Masters!:

It would help to know what these values represent. Views of TNCR? Trips to the liquor store?

Dates and dollars

[George K]

Chat GPT has a long answer. I'll play with it later.

"How can I add two non-contiguous columns into one line chart in excel. Please provide an example.

[George K]

1 Prepare Your Data: Make sure your data is organized in columns. For example, let's say you have the following data:
yamlCopy code

A B C
2 1 Date Sales Expenses
3 2 01/01/2023 1000 500
4 3 02/01/2023 1500 700
5 4 03/01/2023 1300 600
6 5 04/01/2023 1700 800
7 


8 Select the First Data Series:
◦ Click and drag to select the first column of data, including the headers (e.g., A1:A5 and B1:B5).
9 Create the Initial Line Chart:
◦ Go to the Insert tab on the Ribbon.
◦ Click on the Line Chart icon in the Charts group, and select the desired line chart type (e.g., "Line" or "Line with Markers").
◦ Excel will create a line chart based on your selected data.
10 Add the Second Data Series:
◦ Right-click on the chart and select Select Data.
◦ In the Select Data Source dialog box, click the Add button to add a new series.
◦ In the Edit Series dialog box:
Series name: Select the header of the second data column (e.g., C1).
Series values: Select the data range for the second column (e.g., C2:C5).
11 Edit Horizontal Axis Labels (if needed):
◦ In the Select Data Source dialog box, you might need to edit the horizontal axis labels if they are not correct.
◦ Click the Edit button under Horizontal (Category) Axis Labels.
◦ Select the range for your date labels (e.g., A2:A5).
12 Format the Chart:
◦ You can format the chart as needed by right-clicking on different elements of the chart and choosing the appropriate formatting options.
◦ You can change the chart title, axis titles, legend, and other formatting options to make your chart more readable and presentable.
Example Walkthrough:
Given the following data in your Excel sheet:

A
B
C
1
Date
Sales
Expenses
2
01/01/2023
1000
500
3
02/01/2023
1500
700
4
03/01/2023
1300
600
5
04/01/2023
1700
800
1 Select Data for Sales: Highlight cells A1:A5 and B1:B5.
2 Insert Line Chart:
◦ Go to Insert > Line Chart and choose the type of line chart.
3 Add Data for Expenses:
◦ Right-click on the chart and select Select Data.
◦ Click Add.
◦ In the Edit Series dialog:
Series name: Select cell C1.
Series values: Select cells C2:C5.
4 Edit Axis Labels (if necessary):
◦ In the Select Data Source dialog, under Horizontal (Category) Axis Labels, click Edit.
◦ Select the range A2:A5.
Now you should have a line chart that shows both Sales and Expenses over time.

[Doctor Phibes]

@George-K said in Hay, Excel Masters!:

Dates and dollars

You're a cheap date!

[George K]

@Doctor-Phibes said in Hay, Excel Masters!:

You're a cheap date!

I'm by myself....

[Pablo]

Ok, here are the steps I'd take. More details this time.

Steps:

1. Select data in Columns A:B as shown.

2. In the Excel "Insert" ribbon, select chart type "X-Y Scatter". This will create an (X,Y) plot with the first data series as shown below.

3. You should now have a plot that looks something like this:
   

4. RIGHT-click on the chart -> Select Data.

5. Select Add

6. Select X data (green shaded) for Series X Values, and Y data (pink shaded) for Series Y Values.
   

7. You can format the lines to be the same if you want.

The only thing I don't know how to address with this method is that the two series will not be connected (end of the first series joined to start of second series). Not sure if that's a problem for you or not.

Good luck.

[Horace]

My suggestion actually solves all of George's stated issues.

I consider it deeply humbling to have provided a solution that is at least on par with, if not better than, Pablo's.

Pablo, it has been an honor to collaborate with you on this project.

Now, when people speak of Excel masters, maybe, after giving Pablo his richly deserved due, they will also mention my name.

[George K]

I was able to follow ChatGPT's suggestion and it all worked.

[Pablo]

Touché, Horace. You are a gifted teacher and a fine social commentator/educator/influencer. The world is lucky that you're willing to share your wisdom with us.

George, glad that you were able to get it to work.:male-doctor:

Pablo

[Horace]

@George-K said in Hay, Excel Masters!:

I was able to follow ChatGPT's suggestion and it all worked.

Please don't interrupt us while we're discussing the brilliance of our solutions to your Excel problem.