Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [charts]

Graphs, charts and other graphical methods for showing data and their relationships.

0
votes
1answer
48 views

How to get Excel to graph multiple series where series are “mixed” in a table? [duplicate]

I've got a table that contains multiple data series - and they aren't uniformly distributed either. Example below. As you can see there are multiple series here: Income, Short-Term Capital Gain, and ...
2
votes
0answers
41 views

Excel 3D Flat Map

I am trying to display some data on the flat version of the 3D map. But unfortunately the map cuts off down the middle of the pacific ocean so half my data is on one end of the map and the rest on the ...
0
votes
1answer
27 views

Excel: Add multiple tables into a single stacked column graph

I have been asked to make graphs of some evaluation forms, however I don't see how to make readable graphs with the data they gave me: Every group has its own little table with data, the graph they ...
0
votes
0answers
30 views

Excel Resizing axis label area

How do I resize the axis label area and make the long labels wrap? The textbox formatting options are grayed out.
1
vote
0answers
15 views

How to perform automatic graph range extension in Excel (with a constrain)

I'm having a hard time trying to make a graph's range extend automatically. I have made my research and I found this instructive: https://www.officetooltips.com/excel_2016/tips/...
0
votes
0answers
17 views

Animating Bar Charts in Microsoft excel andPowerpoint

I have quarterly data for the no. of Patients and I have to make Bar chart, I want to set the animation in a way to appear the recent quarter bar first and on the right side of the graph and then all ...
1
vote
0answers
13 views

Properly formatting box and whisker data in Excel

I'm doing some social media reporting for my company, and want to look at the statistical distribution of Twitter posts. The dependent variable is the engagement rate (defined as a %) and the various ...
1
vote
1answer
34 views

Combining categories in charts

How do I combine "Chicken", "Moose" and "Pork" into one "Meat"-name, and the remainders into just "Seafood"? I would also want to show how much of the "meat" and "seafood" are "fresh" and "frozen"?
2
votes
1answer
53 views

It is possible to create grouped charts in Excel?

I have many variables with the same time scale, Is there any way to create a grouped chart in Excel? Something like this:
0
votes
1answer
40 views

Excel 2013 chart - setting time intervals in vertical axis

I have time (mm:ss) in the vertical axis of a bar chart.  I want to set the following parameters: min - 0 max - 12:00 major ticks: every 2:00 min (0, 2:00, 4:00, etc.) minor ticks: every 0.5 min (0:...
0
votes
1answer
28 views

Why is Excel not sorting the X axis

I have a number of points where the X value is a number. Excel sees it as a number. But when displaying the chart, it does not sort the X axis. Why?
0
votes
1answer
27 views

Returning row and column value in a large chart if column is in a range

This is for a wastewater oxygen saturation chart used in determining Biochemical Oxygen Demand values. I want to find the intersection value returned to a cell of my choosing. But the catch is that ...
1
vote
1answer
35 views

Excel 2016 Chart showing random dates in x axis

I'm simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart... (showing dates from year 1900-1903 instead of 2018) All ...
1
vote
0answers
44 views

Filter charts on a dashboard to display charts that are on other worksheets in the same workbook [closed]

How to Filter charts on a dashboard to display charts that are on other worksheets in the same workbook? So I know you can create the charts behind each other and move them forwards and backwards. ...
1
vote
1answer
19 views

How to do an Arrhenius plot AKA How to do a reciporcal secondary axis in Excel 2010?

An Arrhenius plot show the logarithm of a property that is thermally acitavted versus the reciprocal temperature aka 1/T. Now is 1/T something that most people are not used to. This is why most of the ...
0
votes
0answers
39 views

Number of points per square in a grid

I have a scatter plot as the example below, and I was wondering whether there is a way to summarize all the points in a square of the grid with the number of points in each square? For example, the ...
0
votes
1answer
50 views

How do I create a self-updating line graph when new information is input every week in Excel table without including the total?

I have a line graph with the performance of two employees.  How do I get Excel to automatically show only the last five weeks’ numbers without me having to select the data manually and without the "...
0
votes
1answer
21 views

Generating a line chart with data over a 10 days but displaying by hours rather than by days

I'm trying to generate a chart in Excel. My problem is, that the chart is being generated by days and not by hours. This is why on the 12th October there's only "a spike" visible and not an actual ...
0
votes
0answers
23 views

How do I make Pie Chart Slices pop up in Microsoft Powerpoint?

I got assigned to make a 3-D pie chart in Microsoft Powerpoint (in Office 365 Pro Plus).  I've already made the pie chart, made sure there are no percentages showing (just the topics).  Now I need to ...
2
votes
1answer
28 views

Format chart colours based on series values

Is it possible to format the colours of a bar chart with a single series based on their values, i.e. anything over 50 would be green, anything below would be red? What I currently have to do is a ...
1
vote
0answers
31 views

Excel 2016 waterfall chart losing data and formatting

I have a problem with a report I built and released into the wild. It contains a waterfall chart with an offset within it linked to a spinner button to change the displayed data range on the fly. ...
0
votes
0answers
19 views

Data Doesn't Appears On My Graph

I have many sheet with numerous formula, and I want to make graph with Formula results. There are hundreds of cells and I don't want to change formula which are formatted as percentage, unless is not ...
1
vote
2answers
69 views

How to set exact chart area size in excel 2016?

I know how to set the size of the diagram, but I cannot find the option for setting the size of the chart area (not sure if this is the correct name in English). The box I want to change is marked ...
0
votes
2answers
55 views

How do I ignore Empty Cells in the legend of a Chart or Graph

I am having trouble with a combination graph in excel specifically with the x axis. I have two columns both go to 1000 but currently only have 13 entries the rest will fill in over time. I have a ...
0
votes
0answers
45 views

Flip the legend horizontally in Microsoft excel chart

I am using Microsoft excel with Arabic language, I would like to flip the legend horizontally, the color on the left and label on the right (figure).
-2
votes
1answer
46 views

PowerPoint Slideshow Error: Server application, source file, or item can't be found

When I double click charts embedded in my PowerPoint slideshow, the following error shows: The server application, source file, or item can't be found, or returned an unknown error. You may need to ...
0
votes
1answer
81 views

How to create two-dimensional column chart in Microsoft Excel for Office 365

I would like to create a two-dimensional column chart in Excel. On the x-axis I would like to plot % of Net Sales, and on the y-axis I would like to plot Gross Margin %. Here's an example: You can ...
0
votes
1answer
28 views

Excel 2010: Create a column chart that groups items and then charts them by year

I am having no end of angst trying to build what I thought would be a simple column chart. My data are in three columns: Player in Column "A", Year (from 2005-17) in "B", Points for each year in "C". ...
0
votes
1answer
30 views

Excel Chart, How to only show monthly/weekly/biweekly data

I currently combine weekly data with daily data for an excel chart. How can I select my data so it is consistenly weekly? Or is there a chart feature to only include the weekly data? I don't want to ...
1
vote
1answer
68 views

Excel 2016: 3D column chart with transparency and no gap

I'm trying to make a decent-looking chart using a 3d representation of three different datasets (3 years, 12 monthly values). If I try with an area chart, I have peaks/valleys at the single data-...
0
votes
0answers
15 views

Aligning scatter points to non-stacked bar charts for multiple series

I am trying to create a combination non-stacked bar and scatter plot, where the scatter plot is aligned to the top of the bar chart. My issue is I am comparing two data series for each identifier, in ...
1
vote
0answers
37 views

Need expanding chart where values per custom user text are counted

Sorry if my question is not clear but I'll explain in more detail here. I have a worksheet that calculates what percentage of a specific users events are mistakes. It figures this out by taking ...
0
votes
1answer
35 views

Where can I find this kind of line graph?

I have this data gave to me in excel spreadsheet 2017 2018 Month Sales TC TA Month Sales TC TA Jan -0.08 -0.08 0 Jan 0.02 0 0.02 Feb -0....
0
votes
1answer
68 views

How to plot horizontal lines in scatter plot in Excel

I would like to plot a time series with two horizontal lines (depicting limits in my case). How do I do this? Example of what I'm trying to achieve (horizontal lines drawn in Paint):
0
votes
1answer
26 views

How to define a graph, based on automatically changing data?

I have an Excel sheet (called Sheet1), where I regularly add some data. By pushing a button, a summary of that data gets written on a next page (called Evolution), and on that next page, there's also ...
0
votes
0answers
31 views

Excel: combine Contour chart with scatterplot

I am able to create a Contour (2D-Surface) Chart. But I can't manage to add points into the Chart like a Scatterplot. I want the Contour Chart to act as a background for my Scatterplot. In the ...
1
vote
1answer
40 views

Excel bar chart widths displaying incorrectly

Using the following data to create a bar chart displays incorrect bar widths. Yes No a 7 0 b 7 0 c 6 1 Shows As you can see, the widths for c are incorrect. The 'No' column is ...
0
votes
1answer
43 views

Unicode character for two *vertical* tildes next to each other? What is that symbol called?

Sometimes on graphs, there is a symbol used to indicate a part of the graph has been ellipsed over to make the graph more compact. It looks something like this: (poor MSPaint mockup) What is that ...
1
vote
1answer
40 views

The graph making tool interprets my data… weirdly

I have sheet from which I attempt to import some data to a graph: However, as you can see, the x-axis labels are not imported either as text nor as dates, but with the first two ciphers correct, and ...
1
vote
0answers
14 views

Display convergence of property in X/Y diagram [closed]

I want to display a diagram, where a property Concept/Realization are shown as points OR multiple projects with the same value in that property (0%,100%;0%,100%;...) can be pulled into a shared bubble ...
0
votes
1answer
49 views

Excel - Bar chart - years in y-axis and variables in x-axis

I'm trying to chart the following: I want a bar showing the total fruit I want the fruit in the Y-axis The years in the X-axis - so you can visually see the impact per year of each category. ...
0
votes
1answer
22 views

The upper data series won't plot a line

I'm planning to plot two series of data on a single graph. The bottom axis is the year. I suspect that they wont plot the upper series because both don't share the same intervals. 2-year intervals for ...
0
votes
1answer
30 views

how to dynamically get an update excel radar chart?

Scenario: An excel form that saves some scores. Each row represents a candidate. Each row has 8 topic cells with an integer score. I can get a nice radar chart that shows each candidate with the ...
0
votes
1answer
48 views

Scatter graph to show margin and revenue for a series of projects

Can a scatter graph show non-chronological data - For a series of projects I want to plot the margin on the Y-axis and the revenue generated on the X-axis. Projects will change position each month as ...
1
vote
1answer
130 views

Plotting time of day distribution in Excel

I have data in excel which lists several events as a time-of-day, in a single column for each day, like so: 1/1/2018 2/1/2018 10:23 00:23 14:53 13:14 16:01 14:19 23:01 16:...
1
vote
1answer
48 views

How to make an excel chart for sales data by year and department?

Assume data like this: Year Dept Sales 2015 Digital 150,000 2015 TV 250,000 2015 Print 100,000 2016 Digital 300,000 2016 TV 245,...
2
votes
2answers
28 views

Can Excel generate a percentage chart from a column with CSV values? How?

Not sure if this is even possible. Its as follows, imagine the following excel sheet: STOCK|VALUE|TAGS ABCDE|10000|Z,X FGHIJ|20000|X,Y KLMNO|30000|X,Y,Z PQRST|10000|Z,Y Total|70000| Now somewhere ...
1
vote
1answer
232 views

Exporting Access query to Excel using VBA and creating a secondary axis chart

In MS Access I have a database. I have Form with three TextBoxes and one Command Button. In txttask_plot user writes Plotid In txttask_from user selects date1 In txttask_to user selects date2 The ...
0
votes
1answer
98 views

On a line chart with a date axis, I want to label each time the “experiment” was checked with 1, 2, 3 etc

My data can be imagined as checking an experiment regularly, recording its values for the line graph, and recording the time it was checked. The times where the experiments were observed were ...
0
votes
1answer
94 views

Copying Chart to Another Sheet with Updated References in Excel

I have made a chart within a sheet in Excel. Within the sheet, the chart refers to specific cells in the sheet to display (i.e. cells that contain my data points). I would like to know how to copy ...