How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have a question about Excel 2013.I am trying to create

Customer Question

I have a question about Excel 2013.
I am trying to create a macro that makes a new series based on part of a cell's name, and plots these different series on the same chart. The data is mixed, and cannot easily be sorted. For example, I have a cell named "Basement 4-4" and a cell named "Basement 4-1". these are scattered throughout other data. I need them to be plotted together as a series called "Basement", and able to be automatically updated as I add more data.
Submitted: 8 months ago.
Category: Microsoft Office
Expert:  Pete replied 8 months ago.
Hi Logan,Could you please attach a sample spreadsheet of data?
Customer: replied 8 months ago.
I have attached a copy of the excel sheet. It doesn't have the code that pulls this data from other spreadsheets, but it gathers it in this summary. From here, I need a macro that can take each type of sample (Basement. Bin1, Bin2, etc.) and plot them as individual series. This macro should be able to be attached to a button that I can press after the data is updated, and will add new points to the correct series.
Customer: replied 8 months ago.
Does the question make sense, or should I try to provide more clarification?
Expert:  Pete replied 8 months ago.
I regret I will have to open this question up to the other experts...
Expert:  Suryanto replied 8 months ago.
Hi,Welcome to JustanswerI am Suryanto and I can write the macro for youCould you send me the sample of chart ?Thank youSuryanto
Customer: replied 8 months ago.
I have attached the summary sheet and the original sheet (JustAnswerSheet and BaselineSandTesting1, respectively). I will be adding more sheets continually, and each sheet corresponds to a name in the first column of JustAnswerSheet. The macro needs to be attached to a button that allows me to refresh the summary page after i click it. The macro must create a scatter plot, with the x axis being the date, and the Y axis being the percent. I need a series for each type of sample (bin1, Bin 2, Basement, etc) and a series for each sieve number (sieve 40, sieve 50, Sieve 40+50). Let me know if I can provide further clarification. Do not worry about the data (LOI, Hot Tensile, Stick point, pH) at this point. Thanks.
Expert:  Suryanto replied 8 months ago.
Hi Logan,A few question:-How about the format in the sheets ? Do the data fill in the range D5..D12 ? But i don't see sieve 40+50 ?-What happen if the sheets not exist ? Do you add the sheets manually ?-A button will be added to summary sheet. If you press the button, it will fill the data in file BaselineSandTesting1 . is that correct ?Thank youSuryanto
Customer: replied 8 months ago.
I have already written a macro that already populates the BaselineSandTesting1 sheets' information into the summary sheet (JustAnswerSheet). This is saved in a macro-enabled workbook, which cannot be uploaded to this site. This macro is already attached to a button and everything.
I just need code that takes the summarized data (in the JustAnswerSheet) and plots it as a scatterplot as described before.The challenge here is that I need separate series for each sample type (Basement, Bin1, Bin2, etc) for each column B, C and D in the JustAnswerSheet. As the number of rows increases as I collect more data, the scatterplot needs to update when I run the macro.I manually add sheets as I collect data.The Sieve #40, Sieve #50 and Sieve #40+50 that I am talking about are columns B, C, and D in the JustAnswerSheet.
Expert:  Suryanto replied 8 months ago.
Ok. Please send me the sample of scatterplot based on data in justanswer.xlsx fileThanks
Customer: replied 8 months ago.
The attached file is kind of what I am going for, but again, it needs to automatically update with new data after I click the button to run the program. It should be able to take the sample name and date from the "Sample" column (column A) in the JustAnswerSheet (ie. "Basement 4-4" is sample type "Basement", date "4/4/2016").Some notes about the chart on the attached file:The x-axis should be the dates, in this case, that would be 3/24/16, 4/1/16, and 4/4/16. I do not just want the x-axis to be a list of all dates between the start and end though, I only want the x-axis to show the dates that were tested. So each point will correspond with an x-axis tick mark labeled with its correct date.The "46892" sample is known as a CoA sample, and there will be changing numbers, but they all need to be plotted as one series (for each sieve type). However, "Truck 46892" is a different type, and should be plotted as a "Truck" series. These numbers will change too.Please let me know if you have any more questions.
Expert:  Suryanto replied 8 months ago.
Hi Logan,Sorry for late replyI can write macro to separate series but have difficulties to plot the data.I will opt out and let other expert help youThank youSuryanto