Ordering Data Table under Pivot Chart

**namharb616** · 09-14-2016, 06:23 PM

I created a pivot chart with a data table underneath, and I'm trying to reorder the data table undernearth to be in the order of

Revenue
COGS
OPEX
EBIT

Or to at least match the chart (see attached.). How do I re order the data table without re-ordering the elements on the chart?

**xlnitwit** · 09-15-2016, 01:47 AM

Hi.

You can't reorder a data table without changing the chart. You might consider using the camera tool to add a picture of a range rather than using a data table. That will allow you to format as required.

Ordering Data Table under Pivot Chart

LinkBack

Thread Tools

Rate This Thread

Display

Ordering Data Table under Pivot Chart

Re: Ordering Data Table under Pivot Chart

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016

Can a Pivot Chart selectively exclude data in the Pivot Table? NO ONE HELPED ME ... :o(

Automating Pivot table and pivot chart creation if data table names unknown

Grouping data columns in a pivot table to create groups of stacked bars in a pivot chart

[SOLVED] Ordering chronologically in a pivot table

Pasting Pivot Chart Format or using slicers Changes Pivot Table data Reference

[SOLVED] Excel 2007 : Is it possible to change source data in pivot table and pivot chart wizard??

Bookmarks

Bookmarks

Posting Permissions