Chart Maker (Graph from Data)

About the Chart Maker (Graph from Data)

Copy a range from Excel or Google Sheets and paste it, open a CSV or Excel file, or type a few label: value lines. The Chart Maker reads each column — text, dates, numbers, ₹ amounts, percentages — and suggests charts that suit the data: a line chart when there are dates, columns or bars to compare categories, a pie for the parts of a whole, a scatter plot for two measures, and a combo chart (columns plus a line on a second axis) when two series have different units.

Switch between column, bar, line, area, pie, donut, scatter and combo at any time, stack the series, and edit the title, axis titles, number format (₹, lakh/crore, K/M, %), colour-blind-safe palettes and legend. Download a PNG at 1×–4× or an SVG, copy the image, or share a link that contains the chart itself — the data travels in the part of the link after “#”, which browsers never send to a server.

Common uses

• Turning a spreadsheet range into a chart for a report, a presentation or a WhatsApp message.
• Monthly sales, expenses, marks or survey answers — without opening Excel.
• Revenue and margin (or orders and conversion rate) on one chart with two axes.
• Sharing an interactive chart with a link that keeps the data private.

How the suggestions are chosen

• Dates or month names in a column → a line chart first (change over time).
• Text labels with numbers → a column chart, or a bar chart when labels are long or there are more than 12 rows.
• One column of positive numbers with 2–8 text labels → also a pie chart (parts of a whole).
• Two series with different units (₹ and %) or sizes more than 20 times apart → a combo chart with a second axis.
• Only numbers → a scatter plot of one against another.

When you paste new data with different columns, the first suggestion is drawn straight away.

Colours and readability

The default Okabe–Ito palette and Paul Tol’s palettes stay distinguishable for people with colour-vision deficiency (Okabe & Ito 2008, “Color Universal Design”). Under WCAG 2.2 success criterion 1.4.11 (non-text contrast), parts of a chart that carry meaning need a 3:1 contrast with what is next to them; colours that fall short of that against the background — such as yellow on white — automatically get a darker outline, and the page shows each colour’s contrast ratio. Text inside bars and slices is black or white, whichever reads better.

Numbers the Indian way

Digit grouping follows Unicode CLDR: Indian grouping shows 12,34,567 (lakh and crore), international shows 1,234,567. Short forms use CLDR’s abbreviations — en-IN: K (thousand), L (lakh), Cr (crore); international: K, M, B — so 1,25,00,000 can read ₹1.25Cr. An axis uses one unit for all its ticks (0, ₹0.5L, ₹1L, ₹1.5L) so labels never repeat.

Share links and privacy

Everything is computed and drawn in your browser; nothing is uploaded. Copy share link compresses the data and settings into the address after “#c=”. Browsers do not send that part of an address to any server, so only people you give the link to can see the chart — but anyone with the link can, so do not share links to private data you would not send in a message. Very large tables make long links, which some apps cut off.

Limitations

• Up to 10,000 rows and 60 columns are read; bar and column charts show at most 300 categories.
• Formulas in Excel files are read as their last saved values; charts inside the workbook are not imported.
• A dot is always read as a decimal point: 1.200 is read as 1.2, and 1.234,56 (dot for thousands, comma for decimals) is not read as a number. A single decimal comma (12,5) is read as 12.5. Write 1200 or 1,200 for twelve hundred.
• One chart per page. For more control over each chart type, use the Bar, Line, Pie and Scatter makers, which share this engine.
• Downloads use your device’s system font; an SVG opened on another computer may substitute a similar font.

Privacy

Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.