+ Reply to Thread
Results 1 to 1 of 1

Setting up chart template

Hybrid View

  1. #1
    Registered User
    Join Date
    11-12-2022
    Location
    Finland
    MS-Off Ver
    Latest
    Posts
    1

    Setting up chart template

    Hello,

    I'm a mechanical engineer student and we use Excel for math and physics. I really enjoy using Excel as well as getting work done efficiantly, I'm always looking for ways to do the same amount of work faster and more efficiently.
    Currently the top frustration is having to manually edit charts every time, even though every chart is the same with just different data.

    In the attached picture you can see the top chart is the default scatter chart.

    Middle one is with a few changes I want (axis titles, horizontal values at low position). I save this chart as a template.

    Bottom chart is the saved template applied to the exact same data. As you can see, it does not use the data like it does in the other charts.

    So the question is why and how do I fix it? Of course, without having to manually edit the charts every time :D I've also included a sample workbook with this situation.


    Another related question. How can I make the axis titles fill in automatically? In 99% of my charts, the titles are written on top of the data column. In this case they are "t (s)" and "a (m/s^2)". I know I can click the "Axis title" and use the formula bar to point it to the cell with the text, but I dont find this being any faster than just typing in the name by hand.

    E: I've also asked this on reddit, but I cannot provide the required link because the forum says I'm not allowed to post a link here.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Catrik; 11-12-2022 at 04:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Setting Up Template Workbook
    By Bart60 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2019, 08:54 PM
  2. setting up a template file
    By gjjh25 in forum Excel General
    Replies: 0
    Last Post: 01-19-2012, 06:14 AM
  3. Setting up page template
    By Chip Pearson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 02:05 PM
  4. Setting up page template
    By John Sullivan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  5. [SOLVED] Setting up page template
    By John Sullivan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Setting up page template
    By John Sullivan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. setting template to have ten sheets
    By The Grinch in forum Excel General
    Replies: 2
    Last Post: 03-11-2005, 06:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1