FG
💻 Software

How to create diagram in spreadsheet with dates on x-axis?

Fresh5 days ago
Mar 15, 202612074 views
Confidence Score0%
0%

Problem

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for Microsoft Excel/GoogleDocs/AnyOtherSpreadsheet), and I want to create a visual interpretation of their …

Error Output

DATE          | 13.oct | 15.oct | 22.oct | 24.oct | 10.nov | 16.dec | 11.jan
Tinus weight  | 2360 g | 2165 g | 2250 g | 2305 g | 2930 g | 4295 g | 51…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to create diagram in spreadsheet with dates on x-axis?

Low Risk

Here's my advice for doing what you want in Excel: Change all of the dates to a format that Excel will recognize, like "13-oct-09." Make sure to include the year, so that it doesn't assume that they're all 2010. Remove the units ("g" and "cm") from …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment